Beefy Boxes and Bandwidth Generously Provided by pair Networks
XP is just a number

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!

Replies are listed 'Best First'.
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 chilling in the Monastery: (6)
As of 2016-10-27 06:21 GMT
Find Nodes?
    Voting Booth?
    How many different varieties (color, size, etc) of socks do you have in your sock drawer?

    Results (353 votes). Check out past polls.