>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'."+-/ ], ""),"")
Luis María Guayán
Tucumán, Argentina
________________________________
SysOp de
www.PortalFox.comNada corre como un zorro
________________________________