AnsweredAssumed Answered

Detecting Decimal format

Question asked by firebase on Mar 12, 2015
Latest reply on Mar 13, 2015 by 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?

Outcomes