1 Reply Latest reply on Oct 7, 2009 12:23 PM by comment_1

    Remove last for characters from a field

    tmgee

      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