How can I copare two strings

[Henry196]

I have two variables one includes Data form the registry and in the other I have put Data from a file.
And Now I would like to compare these two variables.
Have anyone a good idear with I can to this.

Variable one:
Home;Test;Room

Variable one:
Home;Test;Room

In advance the cordial owing to.

[Jop]

If Variable1 = Variable2 Then
    MsgBox "The Variables are the same!"
Else
    MsGBox "They Differ!"
End If

[Phil McKracken]

You could use InStr it would just tell you if string1 is in string2.

InStr(1, string1, string2, 1)

or

if (string1 = string2) then
'do something
end if

HTH

Phil

[Yonatan]

Originally posted by Jop

If Variable1 = Variable2 Then
    MsgBox "The Variables are the same!"
Else
    MsGBox "They Differ!"
End If

This does a case-sensitive comparison. This means, "abc" is different from "ABC".
If you want it case-insensitive ("abc"="ABC"="aBc", etc.) then at the very very very top of the code (first line of the code window), add this line.

Option Compare Text

Alrighty?

[HeSaidJoe]

StrComp Function Example

This example uses the StrComp function to return the results of a string comparison. 
If the third argument is 1, a textual comparison is performed. If the third argument is 0 or omitted, a binary comparison is performed.

Dim MyStr1, MyStr2, MyComp

MyStr1 = "ABCD"
MyStr2 = "abcd" 
   
MyComp = StrComp(MyStr1, MyStr2, 1)   ' Returns 0.
MyComp = StrComp(MyStr1, MyStr2, 0)   ' Returns -1.
MyComp = StrComp(MyStr2, MyStr1)   ' Returns 1.

[Jop]

If you want to use case-insesitive compare you could also do:

If lcase(String1) = lcase(String2) Then
MsgBox "SAME!"
Else
MsgBox "Different!"
End If