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

((defined($_->[0]) && $_->[0] =~ m/^\d+$/) ? $_->[0] : 0)
Am I correct if I assume that here $_ is defined as 'one single digit or maybe a few digits (d+, no spaces and stuff like that in between the digits) and then if this is not the case it should be a 0 (zero)?
Almost. It means that $_->[0] is I would have made it a function to make it more readable:
$ perl use strict; use warnings; use Data::Table; my $t = new Data::Table([ [ 1, 2, 3 ], [ 10, 20, " " ] ], [ 'A', 'B' ] +, 1); # create emtpy column my @newCol = (); $newCol[ $t->nofRow - 1 ] = undef; $t->addCol(\@newCol, 'adding_up'); # Return input if input is an integer, otherwise zero sub to_int_or_zero { my $value = shift; if (defined($value) && $value =~ m/^\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; __END__ A,B,adding_up 1,10,11 2,20,22 3, ,3
--
Andreas

Replies are listed 'Best First'.
Re^3: Data::Table - empty values - avoid warnings
by GertMT (Hermit) on Oct 25, 2007 at 16:14 UTC
    okay thanks a lot. I'm almost there but found out that actually the columns I'm working on have a lot of numbers that have as a decimal separator a 'comma'. For example in the blank spot number like 2,3 as opposed to the 'space'. To work around that I thought to do
    sub to_int_or_zero { my $value = shift; $value =~ s/,/\./; if (defined($value) && $value =~ m/^\d+$/) { return $value; } else { return 0; } }
    but it doesn't work. The 2,3 nicely changes into 2.3 but I'm obviously making a very elementary mistake that I can't understand myself at this moment as the row adds up to ... 3
    : (
        uhm, well. The numbers with comma's as delimiters are just there and just can't seem to get to 5.3 as the result of the calculation. Well, we'll just go on and a hint is appreciated.
        Looked at the regex and now asking myself how to implement that.