[Kc] one way to handle commas in quotes strings in CSV files

Teal ironicface at earthlink.net
Mon May 2 14:59:46 PDT 2011


On 5/2/2011 4:23 PM, David Nicol wrote:
> one way to handle commas in quotes strings in CSV files -- of course
> if your data has angle brackets in it, or form feeds, you'll need a
> different three characters.
>
> while (<>){
>
>       while (/"/){
>          m/[<>\f]/ and die "ANGLE BRACKET OR FF IN INPUT! [$_]";
>          s/"/</; s/"/>/ or die "unpaired quotes in [$_]";
>          1 while s/<(.*?),(.*?)>/<$1\f$2>/;
>          s/[<>]//g;
>       };
>       my @line = split ',',$_;
>       s/\f/,/g for @line;
>
>       ...
>
>
> };
>
>
I usually use _Numeral (example: _1), as replacement values.
The underscore is rare in file bodies, and using a numeral with it gives 
the ability to replace a set of entities.

Of course, order can be very important. :)

Teal


More information about the kc mailing list