Beefy Boxes and Bandwidth Generously Provided by pair Networks
Syntactic Confectionery Delight

Re: Trouble splitting pipe delimited

by Tanktalus (Canon)
on Nov 05, 2012 at 04:40 UTC ( #1002272=note: print w/replies, xml ) Need Help??

in reply to Trouble splitting pipe delimited

I'll second the anonymous monk's suggestion to use Text::CSV (or, better, Text::CSV_XS):

use Text::CSV_XS; use feature 'say'; use warnings; my @tests = ( [q[1|str|foo\\|bar|goo|2323] => [qw(1 str foo|bar goo 232 +3)]], [q[foo\\\\|bar] => [qw(foo\\ bar)]], ); for my $t (@tests) { my $s = $t->[0]; my @e = @{$t->[1]}; my $csv = Text::CSV_XS->new( { sep_char => '|', escape_char => '\\', } ) or die "" . Text::CSV_XS->error_diag( +); $csv->parse($s); my @o = $csv->fields(); say "$s\n @e\n @o\n"; }
The regex/split suggestions fail to take into consideration a doubled escape prior to a delimiter (see the second test). For your example, that may be fine, but your example is so obviously contrived that it can't be taken definitively.


$ perl5.16.2 1|str|foo\|bar|goo|2323 1 str foo|bar goo 2323 1 str foo|bar goo 2323 foo\\|bar foo\ bar foo\ bar
Hope that helps.

Replies are listed 'Best First'.
Re^2: Trouble splitting pipe delimited
by BillKSmith (Vicar) on Nov 05, 2012 at 13:39 UTC
    Thanks for describing some of the "complex cases" that I dismissed so casually.

Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://1002272]
and all is quiet...

How do I use this? | Other CB clients
Other Users?
Others romping around the Monastery: (4)
As of 2018-02-18 07:58 GMT
Find Nodes?
    Voting Booth?
    When it is dark outside I am happiest to see ...

    Results (251 votes). Check out past polls.