Hi Luis,
Thanks for the code. Not quite what I was looking for. Barbara got it for me. Your code will come in handy in another area that I am working on.
Thanks
>>If I have a character string that contains numbers and non-numbers how can I pull out the non-numbers to see if the string is valid for me?
>>
>>If the string was [12' 2 3/4" + 23' 2.45"] this is valid
>>if the string had a character in it except c and m for meter, centimeter and millimeter it is not valid....
>>
>>32cm + 23mm valid
>>12' 3 3/4c not valid
>>
>>
>>THanks
>
>Try with:
>
>lcString = [12' 2 3/4" + 23' 2.45"]
>? CHRTRAN(lcString,CHRTRAN( lcString ,[1234567890cm'."+-/ ], ""),"")
>