Hello, @iskandar-the-pupsi and All,

Use the following regex S/R :

SEARCH ^.*[^A-Za-z\r\n-].*\R

REPLACE Leave EMPTY

Notes :

The ^ symbol ,beginning the character class, is the negation character

The - symbol must be located at the end of the character class as it’s a special** char inside class character

The \R syntax matches any kind of line-break

Best Regards

guy038

Thanks for your elaborated response. Here are some specs:

My pc has 32GB RAM (windows 7 enterprise) Notepad version: 7.5.9 (64 bit) no plugins installed.

The last crash i just copied some random text and pasted it allot of times.

I tried you experiment and got a crash again (https://imgur.com/a/n1NYHhB). This picture also shows the exact error.

@Elvinas-Kavaliauskas

Maybe this is of some interest.

Terry
That worked thank you very much

@Tom-Gibson

Does it happen EVERY time, on every file? It very occasionally happens for me (never have been able to ascertain the reason for it) but if I just save again it works as normal. It’s appears to be a bug, but one I can live with–of course if it happened constantly I would feel differently…

@chcg Thank you very much for the link! I renamed the title respectively.

Hi, @pavel-senatorov, @eko-palypse, @scott-sumner and All,

Ah, @eko-palypse, I didn’t even think that, in a floating or docked group of panels, any left double click on a bottom tab, unset the appropriate panel to its previous location ! Thanks for that hint ;-))

So I’ve updated my previous post and added the Doc Switcher in the list of N++ panels, too.

I admit that most of these mouse gestures are easier to perform than to explain !

Regarding the Find Result panel, today, I did not notice as many problems, as I got yesterday, but it still bugged twice ! It’s probably because of my weak laptop configuration :-(

Cheers,

guy038

There are already some predefined themes you may want to take as starting point for your adaptions.

@오바마
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