Display data from one field in Another one Using the Left or Right Function
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.