Remove last for characters from a field
OK FMP family. Feeling like a total loser right now.
I have a field imported via ODBC from our Accounting System title "Add3". It has a City & State in it. For example: Greenwood, IN. I need to remove the , IN (comma,space,IN) from the right side of the field. The last 4 characters. I know there is a much used simple replace command for this.
Please help the lost!
Mac OS X 10.5 / FMP 9