tags:

views:

733

answers:

6

I am using Perl to convert some XML to JSON. If the XML attribute is a number, I don't want to put quotes around it so that JSON will treat it as a number and not a string. How can I tell if a Perl string is a number (contains only numbers 0 through 9 and possibly one decimal point)?

+15  A: 

Try Scalar::Util::looks_like_number:

E.g.:

use Scalar::Util qw(looks_like_number);

if (looks_like_number($thingy)) {
    print "looks like $thingy is a number...\n"
}
dlowe
just realize that looks_like_number returns true for 'inf', 'nan', '1E02' and probably a few more strings that you might not expect to be numbers.
mirod
why would `1E02` not be a expected to be a number? it's scientific notation for 100.
Nathan Fellman
+14  A: 

The JSON specification provides fairly clear rules on the format of a number, so the following regex should work:

/^-?(0|([1-9][0-9]*))(\.[0-9]*)?([eE][-+]?[0-9]*)?$/
cobbal
+1  A: 

I think this question from perlfaq solves your problem.

Generally the problem is defining what exactly you want to read as number.

  • is "-1.312" valid number?
  • is "inf"?
  • 5.34123412E-03 ?
depesz
+1  A: 

You could just force it into a number then compare that to the original string.

if( $value eq $value+0 ){
  print "$value is a number\n";
}

( Note: it will only work for simple numbers, like 123 or 12.3 )

Brad Gilbert
Is "0" the same as "0e0" or "0.0" or "-0"? Perl normally thinks so, but your test produces the opposite result.
jrockway
A: 

It might be easier for you to just read the XML into a data structure in Perl and let Perl's JSON library figure it out for you. It already has checking for that, so unless your number is actually a string in the XML (e.g. it's got a space after it, etc) JSON->encode() will encode it as a JSON number.

wes
+2  A: 

I think (from recent experiences) that you're making a mistake doing any kind of manual XML->JSON conversion. I encountered many gotchas in the process, not least of which involved incorrectly escaped characters.

I would recommend parsing your XML with one of the many XML::* modules (I used XML::Simple) and then rendering it as JSON using JSON::XS. JSON::XS allows you to convert a Perl data structure to JSON; XML::Simple parses XML to a Perl data structure. In the mean time you can manipulate the Perl data structure as you wish.

Bottom line is that you no longer care about quoting/escaping characters.

mehmet el kasid