Beefy Boxes and Bandwidth Generously Provided by pair Networks
laziness, impatience, and hubris

Re: Split criteria

by arkturuz (Curate)
on Nov 05, 2008 at 09:45 UTC ( #721586=note: print w/ replies, xml ) Need Help??

in reply to Split criteria

You have an unfortunate field delimiter, so something like this might help:

while(<DATA>) { my $str = $_; $str =~ s/!,!/!:::!/g; my @parts = split(':::', $str); print join("==>", @parts), "\n"; }
!A001ST!==>!98!==>!1!==>!01/10/1999!==>!EUROPEENNE!==>!0!==>!EUR!==>!6 +!==>!7!==>!0!==>!98!==>!1! !A001ST!==>!AD,CD!==>!1!==>!20/05/2004!==>!ANDORRA!==>!0!==>!EUR,USD!= +=>!6!==>!7!==>!0!==>!AD!==>!1!

Comment on Re: Split criteria
Select or Download Code
Re^2: Split criteria
by JavaFan (Canon) on Nov 05, 2008 at 09:59 UTC
    That would break as soon as there's a field containing ':::'.
      Sure. It's not in the given data though.

        When trying to come up with a really unlikely temporary separator it's better to use something really unlikely to occur in the real data. Since perl can cope with strings with embedded nulls just fine s/!,!/!\0!/g would be a more robust option.

        The cake is a lie.
        The cake is a lie.
        The cake is a lie.

Log In?

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

How do I use this? | Other CB clients
Other Users?
Others exploiting the Monastery: (9)
As of 2014-12-27 17:43 GMT
Find Nodes?
    Voting Booth?

    Is guessing a good strategy for surviving in the IT business?

    Results (177 votes), past polls