Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Characters
Message
From
04/09/2008 04:19:57
 
 
To
04/09/2008 03:15:21
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:
01344743
Views:
9
This message has been marked as a message which has helped to the initial question of the thread.
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