Nice trick Luis.
Funny tho that when I actually saw the whole thread (for some reason I had asked Universal Thread to show me messages since 12/15/00, it only showed me Rahul's question) that there is ofcoz as in many computer languages different ways to do this. Good to know about the
chrtran function. To bad VS's help is so poorly that there is no reference to the function or similar from functions such as
strtran.
>>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
>
>
>Rahul: Try with:
>
>
>lcChar = "1245&%TTFH&%$fgf+gfgd66%%$$#0045"
>? UPPER(CHRTRAN(lcChar,CHRTRAN(UPPER(lcChar), ;
> "01234567890ABCDEFGHIJKLMNÑOPQRSTUVWXYZ",""),""))
>
- Erik Niese-Petersen
Crazy Dane in USA.