Beefy Boxes and Bandwidth Generously Provided by pair Networks
more useful options
 
PerlMonks  

Re^6: Data::Table - empty values - avoid warnings

by GertMT (Friar)
on Oct 25, 2007 at 18:53 UTC ( #647249=note: print w/ replies, xml ) Need Help??


in reply to Re^5: Data::Table - empty values - avoid warnings
in thread Data::Table - empty values - avoid warnings

okay I'm there for the moment. Thank you all.
I finally put the regex, I was adviced to use, in the place where it works. Code below could be improved because when starting the first column with a 'space' or nothing there won't show up a 0 (zero) in the column but that also wasn't really where I was after.
Thangs again, rethinking the issue made me learn and get to a solution.

#!/usr/bin/perl use strict; use warnings; use Data::Table; my $t = new Data::Table( [ [ "1", "2", "3" ], [ "10", "20", "2,3" ] ], [ "A" +, "B" ], 1 ); # create emtpy column my @newCol = (); $newCol[ $t->nofRow - 1 ] = undef; $t->addCol( \@newCol, 'adding_up' ); # to change , into . in respective columns # not needed for a correct calculation of col3 though $t->colsMap( sub { $_->[0] =~ s/,/\./g } ); $t->colsMap( sub { $_->[1] =~ s/,/\./g } ); # Return input if input is an integer, otherwise zero sub to_int_or_zero { my $value = shift; if ( defined($value) # the regex that above hints pointed at. && $value =~ /^-?\d+\.?\d*$/ ) { return $value; } else { return 0; } } # Put the formula in the empty column $t->colsMap( sub { $_->[2] = to_int_or_zero( $_->[0] ) + to_int_or_zero( $_->[1] +); } ); print $t->csv;


Comment on Re^6: Data::Table - empty values - avoid warnings
Download Code

Log In?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others romping around the Monastery: (9)
As of 2015-07-29 03:28 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The top three priorities of my open tasks are (in descending order of likelihood to be worked on) ...









    Results (260 votes), past polls