LXer: Embedded newlines without a clue
 

Published at LXer:

Sometimes I see tables with embedded newlines and no special marker for "end-of-record". Worse yet, the program that allowed embedded newlines in data items (for example, a spreadsheet) didn't escape the embedded newline characters when exporting as text, or didn't double-quote all the data items so I can tell where a data item begins and ends. How to fix?

Read More...