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.