@Stephen-Yorke
I have now created a regex that will only target commas (,) outside of quoted fields.
So we have (use search mode as regular expression and wraparound ticked).
Find What:,\h*(?![^,]+”)
Replace With:| <----- note there is a space after the | character. This is to put a space after every |.

After running that you then can remove all quotes. I haven’t given you the regex for that, I will leave that for you to do, it is a very easy one to create.

Give it a go and let us know if it suits your needs. Although your 4th field is quoted, this will work on leaving ANY field alone if quoted.

Terry

@guy038 G’dam’ m’man! That’s a niiiiice find. Thank thee! :D. Much obliged’n’all :). And if you wonder why I wrote “G’dam’ m’man!” that way, just listen to https://open.spotify.com/track/1jGvgQkqQtNVj725vg26Ft (it’s an anti-racist song :) ).

… for example, I took a document I happened to have open, printed it to PDF using PDFCreator, and it was fine. I then changed to “VIM Dark Blue” theme, and printed to PDF, and it was still fine.

Debug Info =

Notepad++ v7.5.8 (32-bit) Build time : Jul 23 2018 - 02:03:53 Path : C:\Program Files (x86)\Notepad++\notepad++.exe Admin mode : OFF Local Conf mode : OFF OS : Windows 10 (64-bit) Plugins : ComparePlugin.dll dbgpPlugin.dll DSpellCheck.dll MarkdownViewerPlusPlus.dll NppConverter.dll NppExec.dll NppFTP.dll PluginManager.dll PreviewHTML.dll PythonScript.dll XMLTools.dll mimeTools.dll NppExport.dll

Thank you very much

@Brandon-Tibbitts

You can’t do arithmetic in this (regex) manner. You’re going to need a programming language for that, or perhaps, since you appear to have .csv files, pulling the data into Excel to do the math would work. Good luck.

Hello, @terry-grafff, and All,

Oh, unfortunately, how right you are ! All these advert breaks, pre and post-shows are really a calamity :-((( On French TV, as everywhere else I suppose, they tend to increase, year after year !

We still have, on Net, the possibility to just get, on very few sites, the Knowledge, but for how long ?

Cheers,

guy038

@Scott-Sumner

Ahh, much more innocent. ;-)

@Roland-Haddad

See here.

@Danilo-Schembri

your regex works for me

Find: ([A-Z]) ([A-Z])
Replace: \1_\2
`Search Mode: Regular Expression

gives me

FIELD_ONE
FIELD_TWO
FIELD_THREE

if i press replace all (or repeatedly press replace)

@guy038
i think you ment:
REPLACE \1\x5F\2 instead of REPLACE \1\x20\2

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.