Using Regex to remove Carriage Returns in a CSV file in Notepad++
- by Barry
I have a CSV file I need to clean up. This is a one-time thing so I'd like to do it in Notepad++ if possible.
The CSV file has two fields, one of which is wrapped in quotes. I'd like to remove any Carriage Returns from within the quoted field. I was trying to use this pattern but can't get it quite right...
(.*)\"(.*)\n(.*)\"(.*)
Also correct…