Hi KPrasanth9,
You are right, the IsNumber on INR Value : 21,345.00 is showing up as True,
but the European Value : 21.345,00 is retrieving False.
I tried changing the Currency format in the Region & Language settings of the Control Panel but it did not have any effect. Probably it has got to do with the locale settings that Blue Prism uses to validate the IsNumber function. I do not know where this setting is but I can think of the below options.
1. From the European format value, replace the dot with a comma and a comma with a dot to bring it to a INR format.
You can use the Replace function of BP. But you might have to use a temporary dummy character to replace because the character replaced at first is again the next character to be replaced still retaining the original replacement character. You will find out while doing so. See if you are able to do it without the dummy character.
You can do this in a single multi Calc stage which has three separate functions as follows:
Replace([Data1], ".", "#")
Replace([Data1], ",", ".")
Replace([Data1], "#", ",")
If Input is 21.345,00 then their internal outputs will be as follows:
Replace([Data1], ".", "#") -> 21#345,00
Replace([Data1], ",", ".") -> 21#345.00
Replace([Data1], "#", ",") -> 21,345.00
Now you have the final output converted to its INR equivalent format -> 21,345.00
And you can now apply the IsNumber function to check whether the European currency format was right or not.
I do not know all the possible permutations and combinations of the European currency format.
So you can use this approach only if the replacement formats are as straight forward as this.
2. The second approach is by using Regular expressions:
You can find the appropriate Regular Expression for the European currency format.
As per
this link it is /^\d+(\.\d{3})*(,\d{2})?$/; but you need to test that out or make amendments to it.
Then validate it by using either the 'Extract Regex Values' or 'Test Regex Match' actions of the 'Utility - Strings' VBO.
You can post back what solution you came up with so that it would be beneficial for anyone else with a similar issue.