Re: Text::CSV::Simple parsing issue

A primitive, but maybe working solution is this filter:

perl -pe 's/(?<!,)"(?!,)/""/g' <in.csv >out.csv
[download]

try it, good luck.

Boris

Comment on Re: Text::CSV::Simple parsing issue Download Code

Replies are listed 'Best First'.
Re^2: Text::CSV::Simple parsing issue by dragonchild (Archbishop) on Jan 27, 2005 at 18:38 UTC
`s/(?<!,)"(?![,"])/""/g` You don't want to screw up the doubled double-quotes that are already correctly done. Being right, does not endow the right to be rude; politeness costs nothing. Being unknowing, is not the same as being stupid. Expressing a contrary opinion, whether to the individual or the group, is more often a sign of deeper thought than of cantankerous belligerence. Do not mistake your goals as the only goals; your opinion as the only opinion; your confidence as correctness. Saying you know better is not the same as explaining you know better.	[reply] [d/l]

Replies are listed 'Best First'.

Re^2: Text::CSV::Simple parsing issue
by dragonchild (Archbishop) on Jan 27, 2005 at 18:38 UTC

s/(?<!,)"(?![,"])/""/g

You don't want to screw up the doubled double-quotes that are already correctly done.

Being right, does not endow the right to be rude; politeness costs nothing.
Being unknowing, is not the same as being stupid.
Expressing a contrary opinion, whether to the individual or the group, is more often a sign of deeper thought than of cantankerous belligerence.
Do not mistake your goals as the only goals; your opinion as the only opinion; your confidence as correctness. Saying you know better is not the same as explaining you know better.

[reply]
[d/l]