Remove newline characters in file

Question

I have a text file with comma seperated values which has newline characters in the column values. So it makes the column data split to next line causing data issues.

Sample data

"604","56-1203802","xx","VEN","null","50","1","20","Nï¿½
jTï"
"5526","841328305","yyINC","VEN","null","50","1","20","~R¿½Kï¿½ï
¿½ï¿½}("
"604","561203802","C","VEN",,"null","50","1","20","2ï½aï¿½ï¿½"

Expected Output

"604","56-1203802","xx","VEN","null","50","1","20","Nï¿½jTï"
"5526","841328305","yyINC","VEN","null","50","1","20","~R¿½Kï¿½ï¿½ï¿½}("
"604","561203802","C","VEN",,"null","50","1","20","2ï½aï¿½ï¿½"

I need to remove the newlines inside double-quoted strings.

I tried the below awk command to remove it, but it is not working as expected.

gawk -v RS='"' 'NR % 2 == 0 { gsub(/\n/, "") } { printf("%s%s", $0, RT) }' infile.txt > outfile.txt

The required result would be to remove the LF and CR characters from the data.

I tried solutions for similar question posted, but not working for me.

Newline characters in the file are not visible unless copied to Notepad++ when it shows as CR LF.

Please, do not post an image of the data, we're not going to type it out and use for testing. — James Brown, Sep 25 '17 at 12:10
You got referred to the answer [last time you asked](https://stackoverflow.com/q/46378760/1745001).Read the answer and ask a specific, new question if you have one. — Ed Morton, Sep 25 '17 at 13:22

sat · Answer 1 · 2017-09-25T12:34:30.730

0

You can try this sed:

sed ':loop; /" *$/!{N;s/\n//g; b loop}' file

edited Sep 25 '17 at 12:34

answered Sep 25 '17 at 12:29

sat

14,589
7
46
65

Remove newline characters in file

Sample data

Expected Output

1 Answers1