>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