Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Remove special characters from editbox text
Message
From
12/03/2008 16:23:27
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01301478
Message ID:
01301550
Views:
10
>>>My users often copy and past text from other applications into an editbox in my application that has special characters that show up as a graphic box character. Is there an easy way to test and replace with a space for characters that are outside the basic a-z, A-Z, punctuation, etc.?
>>
>>Use Naomi's to remove the illegal characters. To replace them with a space try
>>
>>lcLegalChars="abcd123,."  etc
>>myField = CHRTRAN(myField,CHRTRAN(myField,lcLegalChars,""),SPACE(LEN(myField)))
>
>Why not just;
>
>
>myField = CHRTRAN(myField,CHRTRAN(myField,lcLegalChars," "))
>
I got "Too few arguements" when I tried it. The first CHRTRAN is only getting two arguements: the original string and the illegal characters from the second CHRTRAN. It doesn't have the replacement characters.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform