Data manipulation - String to Double

Help Activities
1

Hello Everyone,

I have two string as shown below, i want to do data manipulation
String1 = “32.00”
String2= “32”

i want to compare the values from String1 and String2, so i want to do data manipulation in such a way that 32.00 and 32 should be equal.

Appreciate for the responses.

Thanks,
Shiva

2

Hi,

Can yout ry to use CDec or CDbl as the following?

CDec(String1)=CDec(String2)

OR

CDbl(String1)=CDbl(String2)

image

Regards,

3

@shivarajvp555

CDbl(string1)=string2

HopeItHelps!!

4

Hello @shivarajvp555

Assign: number1 = CDbl(String1)
Assign: number2 = CDbl(String2)
Assign: areEqual = (number1 = number2)

If (areEqual = True)
Values are equal, add your actions here
Else
Values are not equal, add your actions here
End If

Thanks & Cheers!!!

5

HI @shivarajvp555

you can try this both ways it will work

CDbl("32.00")=CDbl("32")

cint("32.00")=CInt("32")

image

image