@오바마
and from time to time
ADODB is not so bad choice, I liked it.

@Antonsta
Unfortunately, even when the data is sorted, as you found out the regex still caused the same issue. That’s because it’s still trying to search forward over multiple line.

When the data is sorted this isn’t necessary anymore as duplicates will appear on consecutive lines.

Thus the regex can be changed to:
(?-is)^(.+)\R\K(\1$)

So this will ONLY look for 2 lines together with the same data. The use of the \K is to forget the first line so the line that gets marked is the duplicate line ONLY.

@guy038 gave a detailed rundown on this issue and ways to circumvent it. Have a look at:
https://notepad-plus-plus.org/community/topic/16489/delete-both-duplicates-regexp-macro/15?page=1

Cheers
Terry

@pnedev
thanks.
I have solved using the other nice guy’s help.

Actually, I have went back (not go forward) version 6.something.
Because that version (as far as I know) worked correctly.
-recently, My SSD *ucked up, so all of my computer setting gone.

any way, I’m OK

Thanks… your time and effort.

Hello, @sivabalanarayanan-l, and All,

Easy, just 30 seconds ! Here is the method :

Select the menu option Settings > Style Configurator…

On the left side, in the Language : list, choose the SQL language

At bottom of the dialog, in the User ext : zone, add the extensions, without the dot, separated with a space char. So pks pkb

Click on the Save & Close button to valid these modifications

Stop and restart N++

From now on, each time you’ll open a file, with extension = .pkb or .pks, the SQL language will be automatically selected ;-))

Tested on the last N++ v7.6

Best Regards,

guy038

@chcg
I do not know how to do that

damn auto correct…

[<h1>yzhooo</h1>
<h1>yzhooo</h1>
<h1>yzhooo</h1><h1>yzhooo</h1>
<h1>yzhooo</h1>
<h1>yzhooo</h1>
<h1>yzhooo</h1>](link url)

@Meta-Chuh it is

@Benjamin-Frugoni-Backhaus ,
What is your Notepad++ version?

Thanks!

TextFX is just available for 32bit, not for 64bit. Furthermore there is no maintainer for TextFX.
See https://stackoverflow.com/questions/12699833/textfx-menu-is-missing-in-notepad. You may want to be a beta tester for https://github.com/HQJaTu/NPPTextFX/tree/VS2017-x64/bin/x64

@Scott-Sumner That works perfectly. Thank you very much! I now see how wrong I was with my approach ;)

00 Required\ is the directory the files are stored in(side the zip file) but after extraction / installation they don’t need to be in 00 Required\ since this is just for keeping the zip archive clean.

Dear Friends,
with the specified search criteria, userid=“(NewPC\User\Maya|Computer\Home|XP\Admin)”
I could replace all users. There were only 21 variations and I could find it and type it.

Thanks again for everyone!

That works, thank you so much Scott :-)

CORRECTION – The problem discussed above occurs in BOTH the Administrator and Standard User accounts.

How to fix???