Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Characters
Message
From
04/09/2008 05:58:27
 
 
To
04/09/2008 05:07:29
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:
01344757
Views:
11
You're welcome!

>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
Reply
Map
View

Click here to load this message in the networking platform