Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
To clean a string
Message
 
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00454334
Message ID:
00454340
Views:
34
>>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
>
>
>One of possible solutions:
>
>#define SYMBOLS ':;,./\<>+=-{}[]()#*!?'
>for i=1 to len(SYMBOLS)
>	lcSymbol=substr(SYMBOLS,i,1)
>	cWordString=strtran(cWordString,lcSymbol,'')
>next
>cWordString=upper(cWordString)
Another simpler idea:
#define SYMBOLS ':;,./\<>+=-{}[]()#!?' && Note, I drop *
lcWordString=chrtran(lcWordString,SYMBOLS,replicate('*',len(SYMBOLS)))
lcWordString=strtran(lcWordString,'*','')
If it's not broken, fix it until it is.


My Blog
Previous
Reply
Map
View

Click here to load this message in the networking platform