TEXT MANIPULATION (in CSV format)

[Bill Scherer]

Emile van Sebille wrote:

> You'll need to be more careful than Bill pointed
> out in his reply.  If you know your source data
> is clean, you should have no problems.  Otherwise,
> proceed cautiously.  In particular, if you must parse
> CSV, watch out for embedded commas, eg: name fields
> like "Abe Lincoln, Pres" or address lines like
> "123 Main, Apt C".  You'd be better off if you
> could avoid CSV files by seeing if, for example,
> tab delimited files could be provided instead.

I agree completely.  I was leveraging his example, which was clean of
embedded commas.
If, when creating a csv file, everyone interpreted the 'c' as circumflex
(^) instead of comma (,), life would be better.

-Bill