[RndTbl] CSV files
Glen Ditchfield
gjditchfield at acm.org
Tue Jul 13 08:56:31 CDT 2004
On Monday 12 July 2004 22:59, John Lange wrote:
> if there are any text or memo fields in Access that happen
> to contain CR/LF Access does not strip them or escape them in any way.
> The results in a CSV file with end of line markers in the middle of data
> fields.
IIRC, Access always wraps double quotes around text/memo fields, or at least
can be told to do so. If so, a CR/LF will give you a line with an odd number
of double quotes. A little awk/perl/sed script could look for odd lines and
paste the next line onto it...
More information about the Roundtable
mailing list