Compare Strings

[Keytnknd]

Hi Guys,

I`m having a problem comparing two strings in VBA, I`m used to compare using languages like C, where i can iterate trough each string as string[i].
But in VBA, it cannot be done like that, so I tried using Mid function, but it doenst allow me to use a variable as parameter, so... how can I achieve my goal?

Please Login or Register  to view this content.

[PCI]

What is the issue you have, your code looks nice
Perhaps send a sample of you data

[Keytnknd]

the problem is :
Run time error 5
invalid procedure call or argument

In the line
If Mid(str1, i, 1) <> "*" Then

I`m trying to compare for example app*e and apple , it should give me that they are equal, cause i m not counting the character *

[Keytnknd]

I found the error, the For loop was starting from Index 0, but Mid needs to start from 1

[PCI]

Easy, just ask ... (;-))

[cytop]

Just for info - if you're happier to work with arrays like in C, you can stuff a string into an array in 1 call... (OK - so this is a whole sub, but the 'Split(strConv(...' line is the heart of it).

Please Login or Register  to view this content.