Trimming a string variable in Crystal 8.5 1

[ba4crm]

Hi,
I am trying to add an address field in a report. The database has the address in City, State, Zip format. I only need to display the city in the report. How can I trim off the state and zip? I tried the Left(), but this will help only if I know the exact length of the city name (it is for different city names in the state).

 

[bdreed35]

Try this:

Left({table.address}, Instr(x,",")-1);

~Brian

 

[ba4crm]

Thanks Brian.
When I try to save the formula, I get the error message that a &quot" is missing from infront of the x.
As far as I can tell there shouldn't be a close bracket their since it is not the end of the argument.
Any suggestions?

 

[bdreed35]

I am sorry. I used a variable to tes it and didn't remove the reference.
It should be this:

Left({table.address}, Instr({table.address},",")-1);

~Brian

 

[ba4crm]

Thanks much Brian. It worked perfectly.

Appreciate your input.