Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
To clean a string
Message
From
16/12/2000 01:18:03
 
 
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:
00454346
Views:
31
>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


Rahul, a handy trick is to call CHRTRAN twice:

lcOrig = "abcd ## 55 JJJ )))345 )) +++++"
lcOrig = upper(lcOrig)
lcClean = chrtran(lcOrig, chrtran(lcOrig, "01234567890ABCDEFGHIJKLMNOPQRSTUVWXYZ",""), "")

That way you are certain to get only what you want.

Peter
Peter Robinson ** Rodes Design ** Virginia
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform