How to? Parse CSV file


Scott Mintz
May 20, 2008
Solon, OH, USA
I have a comma separated values file (.CSV) that some of the columns contain quoted text with embedded line feeds (0x0a). Is there a way to use @WORD or @FIELD and have it treat the quoted fields as a single field?

The issue is that a given "row" can span multiple lines within the CSV file due to the LF's.


Similar threads