Separating multiple data in a field from an imported excel table
Imported an excel table to filemaker pro and couple of fields have multiple data separated with a comma i.e.( 3416, 3572, 6708, 1245 ). These multiple data fields are also related and sequentially entered. how can i separate each data and maintaining the fields relationship.