I am very new to FileMaker Pro and I am still learning the ropes. I have a table with a field that has a calculation to retrieve values from a remote table by using the list feature given a certain criteria is met. There are multiple entries that fit this criteria and are contained in one field and are separated by a carriage return.
I am wondering how to parse (im not sure if this is the correct terminology) the text to be in separate records.
In otherwords I am trying to get text that is in one record like this:
into a 3 separate records in a new table:
Any help is appreciated. Thank you!