• Recent
    • Tags
    • Popular
    • Register
    • Login

    Please Note This forum exists for community support for the Mango product family and the Radix IoT Platform. Although Radix IoT employees participate in this forum from time to time, there is no guarantee of a response to anything posted here, nor can Radix IoT, LLC guarantee the accuracy of any information expressed or conveyed. Specific project questions from customers with active support contracts are asked to send requests to support@radixiot.com.

    Radix IoT Website Mango 4 Documentation Website Mango 5 Documentation Website Radix IoT LinkedIn

    RegEx parsing

    Scheduled Pinned Locked Moved User help
    5 Posts 2 Posters 4.4k Views 1 Watching
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • E Offline
      extin
      last edited by

      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?

      1 Reply Last reply Reply Quote 0
      • M Offline
        mlohbihler
        last edited by

        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.

        Best regards,
        Matthew

        1 Reply Last reply Reply Quote 0
        • E Offline
          extin
          last edited by

          @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.. :-)

          1 Reply Last reply Reply Quote 0
          • M Offline
            mlohbihler
            last edited by

            Sure, that works. :)

            Best regards,
            Matthew

            1 Reply Last reply Reply Quote 0

            Hello! It looks like you're interested in this conversation, but you don't have an account yet.

            Getting fed up of having to scroll through the same posts each visit? When you register for an account, you'll always come back to exactly where you were before, and choose to be notified of new replies (either via email, or push notification). You'll also be able to save bookmarks and upvote posts to show your appreciation to other community members.

            With your input, this post could be even better 💗

            Register Login
            • First post
              Last post