Beefy Boxes and Bandwidth Generously Provided by pair Networks
Do you know where your variables are?

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 all is quiet...

How do I use this? | Other CB clients
Other Users?
Others making s'mores by the fire in the courtyard of the Monastery: (4)
As of 2017-09-20 19:03 GMT
Find Nodes?
    Voting Booth?
    During the recent solar eclipse, I:

    Results (238 votes). Check out past polls.