RegEx parsing
-
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?
-
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.
-
@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.. :-) -
Sure, that works. :)