>My brain must be fried today or something. What is the command to obtain the location of the rightmost character(other than a space) in a field. Example, a 25 character field with city and state separated by a space between city and state. If I grab the last two valid characters in the field, I have the state. I can't use the AT function because some cities are two words.
>
>HELP. I know that this is a no brainer! Thanks everyone
>
>Bill
Bill,
I can't resist sharing a solution that you can use with the FOXTOOLS library. After SET LIBRARY TO FOXTOOLS, you can use:
lnwords = Words(lcstring)
lclast = WordNum(lcstring, lnwords)
George
Ubi caritas et amor, deus ibi est