Use local number format for VB functions

Help
1

When I read a number as text, like “100,10” I can’t use CINT to convert it to an Integer.

E.g.
With comma: CINT(“100,10”).ToString → 10010 Wrong result
With dot: CINT(“100.10”).ToString → 100 Right result, but wrong input.

But in Excel VBA it will work out of the box, e.g. Debug.Print CInt(“100,10”) → 100

So it seems like UiPath is not using the local number format as default.
Is there a way to change this in the settings or something?

My workaround is to import System.Globalization and assign:
Convert.ToDouble(“100,10”, new CultureInfo(“no-NO”))

2

Why dont you use replace function to replace comma by dot?

strNum = “100,10”
intNum = cint ( num.replace (“,”, “.”))

this should work

2 Likes
3

I’d prefer if the functions worked as intended. this goes for date fields also.

4

It should work and it will work.

5

Your method works but it would be better to not have to do the workaround. There must be a config to set location, so the functions work as in Excel.