Like operator makes me going mad

hi all,

what I want to do:

AdM = true

aDm = true

aD1M = true

D1233M = true

_AdM = false

a&Dm = false

aD1M/ = false

and so on.

My string is only valid if it consists of A-Z, a-z and 0-9.

I’m not able to get this working with like operator…

Any ideas?

Suggestions?

Thanks in advance

Subject: Like operator makes me going mad

have you tried @contains?

Subject: RE: Like operator makes me going mad

I prefer a clean solution and not to check each character after character.so, I had @contains in mind but found @matches and like and want to do it using them.

Thanks anyway!

Subject: Like operator makes me going mad

Hi there…

Are you looking for a solution in LotusScript or in @Formula ?

Kind regards,

Christopher P. Winkel

Subject: RE: Like operator makes me going mad

if xxx like “[!a-Z0-9]” thenerror message

else

value OK

end if

Also please note this: From A to Z (%$#@!!) which will explain the “a-Z” thing (if you think about it a little).