How to? Parse CSV file

samintz

Scott Mintz
May 20, 2008
1,245
11
Solon, OH, USA
#1
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.

-Scott