AnsweredAssumed Answered

Splitting one field into three

Question asked by BarbaraAdams on Nov 12, 2012
Latest reply on Nov 19, 2012 by BarbaraAdams


Splitting one field into three


     I have a databse that is for our company website. There are a few fields in this database that have numbers (sizes) of our produts in one field. I would like to take that one field and make it into three fields. For example W x D x H is all in one field. I want to make "W" have it's own field, "D" it's own field and "H" it's own field.

     Is there a way this can be done in Filemaker Pro? I have version 8 right now on my Mac but would be willing to get Version 12 if that would make it work. I can make it work on Excel but there is a lot of formatting that has to be done to accomplish it.