[SOLVED] How to remove line breaks from lines ending with a comma

jasonws · 11-10-2010, 11:48 AM

Hi, I have a CSV file that's created in an application that can't output lines longer than 250 characters. Unfortunately, the data fields, all together, are longer than this. how would I remove the line break from every line that ends with a comma?

For example:
A,B,C
D,E,
F
G,H,I

becomes:
A,B,C
D,E,F
G,H,I

Thanks!

jasonws · 11-10-2010, 12:03 PM

Nevermind. I found this Concatenating the two lines in a file where any line starting with a comma joins the previous line. I particularly liked the sed solution:

Quote:

sed -e 'H;$!d;x;s/\n,/,/g' file > newfile