AnsweredAssumed Answered

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

Question asked by billsayagh on Jun 5, 2014
Latest reply on Jun 5, 2014 by StylisticGambit

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.

      

Outcomes