Scenario: Date or number functions do no use local date/time format. E.g. on a German system, the date.today function returns 1/1/2017 instead of 01.01.2017. Same for CDbl which takes “,” as thousands separator.
Steps to reproduce: Use any number or date function that produces different results base don the local settings. Tried the CDbl conversion from a string number (“31.345,12”) in UiPath and Excel. Excel uses local settings, UiPath not.
Current Behavior: Wrong separators
Expected Behavior: Separators based on system localle
Calls made within UiPath the default culture is invariant, unless you specifically provide a different one.
CultureInfo.InvariantCulture that It is associated with the English language(‘en-US’) but not with a country or region.
There was already a thread and discussion available on the forum. you can look into this for more info
I think I’ve seen this thread and also used the invariant culture in a former project. But isn’t it a specific parameter for certain functions? How would I convert a string of 34.345,12 into double by using CDbl?
The purpose of the convert is, I have a net amount from SAP and from an associated Excel file (CSV format). The SAP amount is from an OCR operation and I want to compare the 2 amounts as an additional check. So I can only get the numbers in string format. I can replace the “,” and “.”, but I prefer to convert them.