I've got a csv file (the column separator is "<;>" ,the text delimiter is the double quote and the row separator "crlf") of more than 18000 lines.
However,many of the data contained within the text separator do contain "crlf" , this create issue when trying to import or validate the file structure as well as other one.
"2"<;>"1305767"<;>"MSCUFH613249 [CRLF] 199PACKAGES"<;>""<;>"Y"[CRLF]
I've tried the suggestions found on the following posts to no avail.
I've been able using Notepad++ to remove the Carriage return with the Find\Replace with the Wrap Around and Extented options On. However this also replace the row delimiter at the end of the line.
I would like to replace all "\r\n" or CRLF within any text delimiters("") with a blank space.