1 2 Previous Next 19 Replies Latest reply on Jun 19, 2017 1:45 PM by bigtom

    Parsing Text From Single Record to Multiple Records?

    gandhibeats

      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!

        1 2 Previous Next