Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Characters
Message
From
04/09/2008 05:07:29
 
 
To
04/09/2008 04:19:57
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Vista
Network:
Windows 2008 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
01344739
Message ID:
01344750
Views:
12
thank you very much,
>Create a string of all legal characters, and compare it to the field value
>lcLegal=[abcedefghijklmnopqrstuvwxyz0123456789.,'" ] + upper([abcedefghijklmnopqrstuvwxyz]) 
>*You must modify the previous line to fit your need
>if !empty(chrtran(fieldx,lcLegal,'')) && the field contains illegal data
>  replace field2 with 111
>else
>  replce field2 with 1
>endif
>
>
>>hi all,
>>
>>if the field have data as 123456Arabic characters as (568329 ???)
>>  replace field2 with 111
>>else
>>replce field2 with 1
>>endif
>>
>>thank for help
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform