AnsweredAssumed Answered

Remove last for characters from a field

Question asked by tmgee on Oct 7, 2009
Latest reply on Oct 7, 2009 by comment_1

Title

Remove last for characters from a field

Post

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!

 

Cheers!

 

tmgee

Mac OS X 10.5 / FMP 9 

Outcomes