Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Force field content
Message
From
11/09/2008 06:21:26
 
 
To
11/09/2008 06:03:47
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Vista
Network:
Windows 2008 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
01346533
Message ID:
01346540
Views:
8
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
Map
View

Click here to load this message in the networking platform