LXer: Embedded newlines without a clue
by LXer from LinuxQuestions.org on (#4V5DG)
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...
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...