11 Replies Latest reply on Mar 13, 2015 4:16 PM by firebase

    Detecting Decimal format

    firebase

      Title

      Detecting Decimal format

      Post

      I have a script that is reading out prices from webpages. Its easy to detect the sourounding code and mark it as the regions where the price would be to read out.

      My problem is that I am not able to find the right way to detect the right decimal number format.

      is can be

      1.000,00

      1,000.00

      1000,00

      1000.00

      And what ever is possible.

      I used getasnumber in the field I want to write this into but there needs something else to be done.

      Untill now I tried to convert the "," and "." trough different IFs into the right format but it was allways buggy.

      Any help?