Search code examples
regexnotepad

regex command to remove word wrap in cells of .csv file

i have a .csv file that contains word wraps in some its cells (which makes it difficult to further work with the file). for example:

"......;"Test 
File";......."

i hope it's clear what i mean. Is there a way to remove the word wrap with a regex command? So that the cell in the .csv file would look like this instead:

"......;"Test File";......."

Solution

  • Try Regex: \n(?!") Replace with (1 space)

    Demo

    Assuming that each line in the file starts with a ", this regex looks for a new line that doesn't start with " and replaces with 1 space.