Re^3: Change decimal point temporarily

[ikegami]

in reply to Re^2: Change decimal point temporarily
in thread Change decimal point temporarily

use Scalar::Util qw( looks_like_number );

my $s = 123.45;
$s =~ s/\./,/ if looks_like_number($s);

Works even better than setlocale because you are surely starting with the number in string form if you don't know whether a column contains a number or not.

[Jenda]

use Scalar::Util qw( looks_like_number );
print looks_like_number('12,48');
# --> 0

He's PARSING a csv (or more probably a tab or semicolon separated file) so he needs to go exactly the other way around. Accept 12,48 and treat it as a number.

[ikegami]

I don't think so. That's the opposite of what he said (changing the decimal point from "." to ","), and it's the opposite of what his code does.

I see what you mean, but it still make no sense since he says setlocale works.

$ perl -we'use POSIX; setlocale LC_NUMERIC, "fr_FR"; print 0+"123,45"'
Argument "123,45" isn't numeric in addition (+) at -e line 1.
123

[lima1]

Hm, It seems to work if you use locale:

perl -we 'use POSIX; use locale; setlocale LC_NUMERIC, "fr_FR"; $x = "
+123,45"; $x+=0.1; print $x; setlocale LC_NUMERIC, ""; $x += 0.1; prin
+t $x;'

Update: this does not work:

perl -we 'use POSIX; use locale; setlocale LC_NUMERIC, "fr_FR"; $x = "
+123,45";  print $x; setlocale LC_NUMERIC, ""; $x += 0.1; print $x;'

So what I do now is to add 0 if it looks_like_number() and everything works fine. At least what I've tested until now...