3 Replies Latest reply on Jun 5, 2014 12:56 PM by StylisticGambit

    Display data from one field in Another one Using the Left or Right Function

    billsayagh

      Title

      Display data from one field in Another one Using the Left or Right Function

      Post

           Sorry for the newbie question, I am new to Filemaker and i am finding it somewhat hard to make the transition from the way i am used to doing things in excel.

           I have a field called Product Code with data formatted like this MIL-48-00-9542. I am trying to create a specs field that would be called model that would show only 48-00-9542, in a different field in the same table.

           In other words ProductCode: MIL-48-00-9542 => Model: 48-00-9542.

           If anybody can help me i would greatly appreciate it.