General information
Category:
Coding, syntax & commands
Environment versions
Network:
Windows 2008 Server
No its not.
lcString = "ABCDEF"
?LEN(CHRTRAN(lcString,"ABCDEFGHIJKLMNOPQRSTUVWXYZ","")
0 = bad string all alpha
same with numbers.
I think you need something like
IF LEN(CHRTRAN(lcString,"ABCDEFGHIJKLMNOPQRSTUVWXYZ","") >0 AND LEN(CHRTRAN(lcString,"1234567890","") >0
string is ok
>Hi Moises,
>
>you could use regular expressions, but if there is no special position for numbers and letters you could do sometghing like this:
>
>lcString = "7CM4991"
>?LEN(CHRTRAN(lcString,"0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ","")
>
>In case of LEN() = 0 your String is OK.
>
>>I have a field
>>
>>Suppose use enter data to the field, as would like the behaivor as below:
>>
>>"ABDF"
>>= messagebox ("Field must contain numbers and letters")
>>
>>"8887"
>>= messagebox ("Field must contain numbers and letters")
>>
>>7CM4991
>>= messagebox ("OK")
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only