GetBefore( ) function

[izachar]

I have a field that has the city and the state in it.I wan to break it abart. There is a delimiter between the two ",".
I read on the crystal decisions web site that I can use
GetBefore ({PM Property Info.PROPERTY_CITY_ST},"," ) but the function is not there any one know if I need to download it.
I just need the city

thanks

 

[synapsevampire]

Try:

left({MyTable.MyCityST}, instr({MyTable.MyCityST}, ",&quot-1)

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com