Formula to count and display to the Right

[ronnutter]

Hi,
Please help. I have a field {name}. In the {name} field is a city name and state in the following format:

las vegas, nv

I need a formula that will only display the city name, something like the Right function but to count the other way, four spaces to the right. Result should be:

las vegas

Thanks,

 

[kenhamady]

One of these should work. The first comes 4 characters from the end, the second goes up to just before the comma.

{name} [ 1 to Length ({name}) - 4 )

or

{name} [ 1 to Instr({name},',') -1 ] Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guide to using Crystal in VB

http://www.kenhamady.com/

tek@kenhamady.com