>>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,
>Nice solutions so far. Since complexity pays more, try these also :
>cState = substr(myField,rat(" ",alltrim(myField))+1)
>cCityOnly = substr(myField,1,rat(" ",alltrim(myField))-1)
>* or more payment
>cCityOnly = stuff(myField,rat(" ",alltrim(myField))),len(myField),"")
>Cetin
I just made you a partner, Cetin! Thanks for the complexity while preserving functionality. UT members are really good!
CySolutions, Medical Information Technology
You're only as good as your last
success, so . . .If it works. . .don't fix it!