[vox-tech] CSV with rogue EOLs

[Bill Kendrick <nbs@sonic.MAPSnet>]

Has anyone got a Perl or sed script handy that can take a CSV
(comma-separated values) text file like this:

  "1234","Hello","ABCD"
  "1235","Hello
  there","XYZ"
  "1236","Goodbye","LLLL"

and make it look like this:

  "1234","Hello","ABCD"
  "1235","Hello there","XYZ"
  "1236","Goodbye","LLLL"

e.g., wherever there are EOLs _within_ fields (between quotes), have it
replace those with something (in my example above, just a space)


I'm unfortunately dealing with Excel, and even it is too stupid to remember
when its within a field, so you end up with a spreadsheet like this:

  1234  | Hello   | ABCD
  1235  | Hello   | [blank]
  there | XYZ     | [blank]
  1236  | Goodbye | LLLL

I've dealt with this issue before, but it was years ago.  And I used C. ;^)

Thx!

-bill!

_______________________________________________
vox-tech mailing list
vox-tech@lists.lugod.org
http://lists.lugod.org/mailman/listinfo/vox-tech