Example
NppExec [sourceforge] allows you to execute commands and scripts from a console window in Notepad++. It can be found in the menu bar at Plugins -> NppExec or just by simply hitting the F6 key (the shortcut Ctrl+F6 will run the latest command) .
Example: the following will
- Set the console to
output_var: on, meaning we can use the output of the console - run a SQL query from the file
C:\scripts\query.sql - take the output from the console and put it into the active file at the cursor
- close the console
- clear the console
NPE_CONSOLE v+
sqlcmd -S 111.111.1.1 -U UserName -P "password" -i C:\scripts\query.sql
sel_settext $(OUTPUT)
NPP_CONSOLE 0
cls
NppExec also allows you to save your scripts. After saving them, you can go to Plugins -> NppExec -> Advanced Options and run it anytime Notepad++ starts, closes, or even add that script to the Plugin commands using Macros. For example, by saving the above example as a "Run Query", I could use the bottom left fields in the Advanced Options to add it to the menu.
The script will be available as a macro after a restart of Notepad++ as long as the "Place to the Macros submenu" box is checked.
Finally, a shortcut can be assigned to the macro/command by using Settings -> Shortcut mapper -> Plugin commands.
