RegEx parsing

[extin]

How do I parse numeric data with comma separator? Not that good with java regex, or regex in general.
I was able to get the correct reading parsed (relative humitidy on a nearby weather station) as alphanumeric but I can't get the whole value. Values are in format "00,0".

All numeric values in Mango have period, is it possible to change them to suit locale ie. comma?

[mlohbihler]

That's actually not regex, it's a Java DecimalFormat. See http://java.sun.com/j2se/1.4.2/docs/api/java/text/DecimalFormat.html.

Not that this will help, since for "12.3" a "##,#" returns 123 and "##.#" returns 12. The way to get the correct value is to parameterize the format with a locale, which Mango doesn't currently support.

[extin]

@mlohbihler said:

That's actually not regex, it's a Java DecimalFormat. See http://java.sun.com/j2se/1.4.2/docs/api/java/text/DecimalFormat.html.

Not that this will help, since for "12.3" a "##,#" returns 123 and "##.#" returns 12. The way to get the correct value is to parameterize the format with a locale, which Mango doesn't currently support.
Well that kinda helps. If I can get 123 then I can have meta point to show the actual value.. :-)

[mlohbihler]

Sure, that works. :)