Compare 2 values

Hi Abrar,

I have felt your pain at some point in my life. The point was that I did not know that string compares differently from ints.The quotations in a string mean a lot and simple tab space does not equal to space. My apologies for posting a reply in vbscript but this is what I used and helped me get my sleep back.

Function CleanString(strSource)
    'On Error GoTo CleanStringErr
    ' convert tabs to spaces first
    strSource = Replace(strSource, vbTab, " ")

    ' convert all CRLFs to spaces
    strSource = Replace(strSource, vbCrLf, " ")

    ' Find and replace any occurences of multiple spaces
    Do While (InStr(strSource, "  "))
        ' if true, the string still contains double spaces,
        ' replace with single space
        strSource = Replace(strSource, "  ", " ")
    Loop

    ' Remove any leading or training spaces and return
    ' result
    CleanString = Trim(strSource)
    Exit Function

'CleanStringErr:
    ' Insert error-handling code here
End Function

Cheers,

Mpho

Since your two values are strings, I would trim them for the comparison to see if that gives the answer you expect

if (aqString.Trim(Value1)==aqString.Trim(Value2))

Try doing one of these:

Change function declaration to:

function CompareValues(Value1 : String,Value2 : String)

OR

change comparison expression to

Value1.valueOf() == Value2