Curious that you’re not doing that in your SQL query, but I’m assuming you want to do that using Find/Replace in Notepad. Other assumptions: 2) The column divider appears to be a space, but also could be a tab. 3) The words in the Name column will always begin with a letter and never a number (for example, this value would not be present in the Name column: Auto 1CF Asset Pricing Procedure). 4) Only a single space separates the words in the Name column. 5) The ROW_ID column will always begin with a single digit and a hyphen and will never contain spaces. This could be incorrect, but based on your sample data, that seems reasonable.

So with your output open in Notepad++, open the Replace dialog (Ctrl+H works) and click the bottom radio button Regular expression. Also make sure the Match case checkbox is not checked. You’ll need to do 2 Replace operations. First, paste the next line into the Find what box:
[ ]([a-z]\S+)
(?# Space followed by letter followed by non-space chars)
and paste this into the Replace with box:
_spc\1
(?# _spc followed by stuff in parentheses)
Click the Replace All button and it should replace all spaces, except for the ones in front of the second column, with _spc.
Then paste this into the Find what box:
[ \t]+(\d-\S+)
(?# 1 or more spaces or tabs followed by a digit then a hypen then non-space chars)
and paste this into the Replace with box:
=“\1”
(?# =" followed by stuff in parentheses then by ")
Click the Replace All button and it should replace all spaces before column 2 with =" and put a " after the value.

Obviously, check the result to make sure the assumptions were correct and nothing unexpected happened, but that should get you the result from your example.

Hello JAGDISHSINH,

i have seen already seen customize toolbar plugin but it won’t allow me to add my custom buttons and custom command.

You can do both with the Customize Toolbar plugin.
Please read this thread.

Best regards.

I found a partial answer to my own question c/o this video tutorial at https://youtu.be/ERqrmk7kAYI , which explains how to configure tag completion and hints in Settings>Preferences>Auto-completion, and applies to both versions. That said, it would still be great to have a tag chooser panel similar to the one for ASCII characters.

You also made this reply about an hour ago.

@Scott Summer
Thanks a lot, works fine. Topic closed.

If you download the Notepad++ source code, there is a file called keys.h in the …/PowerEditor/src/ directory which contains the hex values which correspond to the decimal (which makes it harder!) Key= values in your shortcuts.xml file.

The file called menuCmdID.h in the same folder can be of help with the ID= values. Also scintilla.h in the …/scintilla/include/ directory.

At one time @guy038 was attempting to compile all of this information together in a document (see https://notepad-plus-plus.org/community/topic/12576/list-of-all-assigned-keyboard-shortcuts/6). I wonder if he ever found a good place to post the results…

Simplest solution is to encode UTF-8 with BOM.

Hi, Dario

At the end of my previous post, I said :

If you don’t want to repeat the word Fred, several times in the search regex,…

and I gave a second, but rather complicated, regex !

Thinking about it, here is a third and more simple regex, for the same purpose :

SEARCH (?-s)<p[^<>\r\n]*(\K class="(fred)"| class=".+\K (?2)| class="\K(?2) )

REPLACE Leave EMPTY

Remember that the (?n) syntax, called a subroutine call, represents the regex enclosed in the nth pair of round brackets, when going through the regex, from left to right and can be placed after of before the group to which it refers !

In our example, the regex is, simply, the string fred and the (?2) forms are located after the second group (fred)

It’s very important to note that the similar regex, which uses back-references, does not work ! Indeed, the regex :

(?-s)<p[^<>\r\n]*(\K class="(fred)"| class=".+\K \2| class="\K\2 ), matches, only, the two lines, below :

<p class="fred">some text</p> <p id="12345" class="fred">some text</p>

Why ? Well, these positive matchs concern the first case of the alternative. When it tries to match the two other cases of the alternative ( " class=".+\K \2" or " class="\K\2 " ) the group 2 does not exist, as the first part of the alternative is not used !!

Cheers,

guy038

If the disk was the one containing your Windows system, I think the whole operating system may have become unstable when the disk filled up - possibly aborting NP++. It is not a good idea to run with nearly full disks, but of course a program that gets stuck in a loop can easily fill a disk.

@Donald-Bellefuil

I wonder if you have been experimenting with the shortcut mapper and disturbed the definition of the Enter key. Go into the Scintilla tab, and see what Enter is bound to - it should be bound to SCI_NEWLINE