Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
To clean a string
Message
 
To
15/12/2000 23:42:15
Rahul Murarka
Sys-Con Engineering
Kolkata, India
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00454334
Message ID:
00454437
Views:
26
>Dear Sirs,
>
>Regards & Hello
>
>I want a small prog or solution to clean a string which will remove all things execpt numbers and Alphbets.
>
>e.g:
>
>Original string is "abcd ## 55 JJJ )))345 )) +++++"
>Result I should get: "ABCD55JJJ345"
>RESULT IS IN UPPERCASE:
>
>
>EARLY REPLY IS APPRICIATED.
>
>RAHUL

Look at the StrFilter() function in Foxtools. If the library is set:
#DEFINE ALPHANUM "ABCDEFGHIJKLMNOPQRSTUVXYZ0123456789"
? StrFilter(UPPER("abcd ##  55 JJJ )))345      )) +++++"), ALPHANUM)
George

Ubi caritas et amor, deus ibi est
Previous
Reply
Map
View

Click here to load this message in the networking platform