Check do numbers with different format match

Help Studio
, ,
1

Hi, I currently have numbers from two different sources formatted differently, one from excel and one from a software I’m using.

The ones from excel looks like this:

image
image157×506 3.45 KB

While the ones from the software looks like this:
image

Currently I’m using a for each loop, then copy the value from the software and getting the number with get clipboard, then saving it to a variable, while saving the number from excel to another variable.

How can I compare the two differently formatted numbers?
The bot should be able to differentiate positive and negative value.

2

we could convert it into the corresponding number type for the check:
grafik

3

What does the CDbl do?
Where should I put this command? In the if condition?

4

Are different methods to parse a string into Double

Yes you can do: CDbl(stringVar1).Equals(CDbl(StringVar2))

5

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.