>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