Beefy Boxes and Bandwidth Generously Provided by pair Networks
Perl Monk, Perl Meditation
 
PerlMonks  

Re: Re: csv to flat-file

by jreades (Friar)
on Nov 28, 2002 at 09:20 UTC ( #216261=note: print w/ replies, xml ) Need Help??


in reply to Re: csv to flat-file
in thread csv to flat-file

All of these solutions are great, but they all assume that you can't have a comma as part of the field value.

Given that this is almost always possible, you have two choices:

  1. If commas as part of the field are escaped, then you can use a negative look-behind assertion:split(/(?<!\\),/, $line)
  2. If commas are not escaped, but can form part of a field delimitted with quotation-marks of some kind (" or ') then things get a lot uglier. I believe that there's a regex that could do it, but I could never figure it out and had to switch to a while loop and essentially chew through a line.

HTH


Comment on Re: Re: csv to flat-file
Download Code

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://216261]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others taking refuge in the Monastery: (7)
As of 2015-07-29 10:18 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The top three priorities of my open tasks are (in descending order of likelihood to be worked on) ...









    Results (263 votes), past polls