AnsweredAssumed Answered

Parsing Text From Single Record to Multiple Records?

Question asked by gandhibeats on Jun 13, 2017
Latest reply on Jun 19, 2017 by bigtom

Hello all,

 

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:
RED
GREEN
BLUE
______

 

 

 

into a 3 separate records in a new table:
RED
____
GREEN
_____
BLUE
_____

 

Any help is appreciated. Thank you!

Outcomes