Locate a certain letter in a name

[dukkse]

Hey!!

We have a client naming standard that ends with number, ex. ws0004, ws0125 and so on.
It want to determine what the fourth last number is (always the fourth last number) to see if it is a client with a number higher that 1000.

How do I easiest get this info??? I need to use it in a IF.. Then, like If xnumber > 1 then blabla, else bla bla

Thanks

/Daniel

 

[PHV]

What about this ?

tst=Right(ClientName,4)
If IsNumeric(tst) And tst>="1000" Then
  blah blah
Else
  Another blah blah
End If

Hope This Help
PH.

 

[dukkse]

Hey PH.

Worked great, but since it is numbers I removed the " " around 1000.

Thanks

 

[PHV]

dukkse, if you're absolutely sure it is allways numbers, you can also suppress the IsNumeric test. If not, keep the quotes around 1000 to avoid sort of Type mismatch error.

Hope This Help
PH.