Beefy Boxes and Bandwidth Generously Provided by pair Networks
P is for Practical

Minor addition

by Purdy (Hermit)
on Jul 08, 2003 at 13:39 UTC ( #272278=note: print w/replies, xml ) Need Help??

in reply to Re: newbie regex question: substituting repeating occurences for different replacements
in thread newbie regex question: substituting repeating occurences for different replacements

Just to make a minor point (plus get my first post in for 2003! ;)), the original poster's data has semicolons as the separating character instead of the default comma, which can easily be specified in Text::CSV_XS's sep_char attribute in the new() method. Hope I'm not doing anyone's homework:
#!/usr/bin/perl -w use strict; use Text::CSV_XS; my ( $csv, $xml ); $csv = Text::CSV_XS->new( { 'sep_char' => ';' } ); $xml = ''; while( <DATA> ) { chomp; if ( $csv->parse( $_ ) ) { my ( $line, $n, @fields, $field ); $line = '<row>'; $n = 1; @fields = $csv->fields(); foreach $field ( @fields ) { $line .= "<col$n>$field</col$n>"; $n++; } $xml .= $line . "</row>\n"; } else { print "parse() failed on this line: " . $csv->error_input() . +"\n"; # die? } } print $xml; __DATA__ a;b;c;d;e f;g;h;i j;k l m;n;o
$ ./
There's probably an XML package out there should your required output become more complex or you want to guarantee that you are using a standardized and optimized solution.



Replies are listed 'Best First'.
(jeffa) 3Re: substituting repeating occurences ... (Text::CSV_XS / version)
by jeffa (Bishop) on Jul 09, 2003 at 21:34 UTC
    Here is another approach which uses Text::CSV_XS and, gulp, CGI:
    use strict; use warnings; use Text::CSV_XS; use CGI::Pretty qw(-any); my $i; my $csv = Text::CSV_XS->new({sep_char => ';'}); while (<DATA>) { $i = 0; warn and next unless $csv->parse($_); print CGI::row(map eval "CGI::col@{[++$i]}('$_')", $csv->fields); } __DATA__ colContents;nextColContents;lastColContents colContents2;nextColContents2;lastColContents2 colContents3;nextColContents3;lastColContents3 a;b;c;d;e f;g;h;i j;k l m;n;o
    The -any pragma in is pretty nifty, you can actually use it to create XML. No guarantees on valid XML, of course. Just be sure and either append the CGI package name or use the OO interface (else Perl will complain that main has no such method). I was able to increment the <colN> tags by using an evil eval trick. That was the toughest part of this code. Drop that requirement and utilize's distributive shortcuts feature thingy:
    use Text::CSV_XS; use CGI::Pretty qw(-any); my $csv = Text::CSV_XS->new({sep_char => ';'}); $csv->parse($_) and print CGI::row(CGI::col([$csv->fields])) while <DATA>;


    (the triplet paradiddle with high-hat)

Log In?

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

How do I use this? | Other CB clients
Other Users?
Others about the Monastery: (4)
As of 2019-11-12 00:53 GMT
Find Nodes?
    Voting Booth?
    Strict and warnings: which comes first?

    Results (64 votes). Check out past polls.