I have a situation where I want to compare if two numbers are equal. The first number, lets call it A, is from Excel, and the second number, B, is from an invoice system where I use Get text to store it in a string variable.
A = 23500,00
B = 23 500,00
When I compare if they are similar, the check will always fail, because of the extra space (thousand separator) in number B. It should not be a problem to remove the space before comparing the two numbers, but for some reason It does not work using Replace(" ", “”) on number B. The number is unaffected when I write it to log. That has never failed before…
So, do I have to use some alternative method to convert it to string?
Or are there some other methods you guys could suggest so that the two numbers appear in the same format, before I compare them?
By the way;
Number B is a part of an array, as I had to remove som text before the number (“Sum:23 500”), so I split by “:”. But it is still a string, so it should not have any impact.