How to compare 2 values equally

Help Insights
,
1

I have 2 string values 1,000.00 and 1000 i want both of them to matched
how can i achieve

2

Hi @T_Y_Raju,

You can convert both string expressions to double and compare them. The code below may be useful.

isMatch = (CDBL(str1) = CDBL(str2))

isMatch will be true, if the strings match.

You can do like this, or just put the expression to if’s condition block.

image
image1050×493 15.3 KB

Regards
Ömer

3

you can convert both values to Double with the following function:

CDbl(var1) = Cdbl (var2)

just take into consideration the following:

if your number, was “1.000,00” instead of “1,000.00”, you’d need to modify the string first, since the 1st value, would throw an error. Take that into consideration, in case you see the other format.

image

4

HI @T_Y_Raju

You can also try with CInt

(CInt(String1)=CInt(String2))

image

Regards
Gokul

5

Thank you Its working with your solution provided.

6

You are welcome @T_Y_Raju,

I’m glad it works, you can mark it as solution so that other people can benefit as well.