7 Replies Latest reply on Jul 21, 2016 9:41 AM by Benjamin Fehr

    Best way to find and return specific text values from a field?

    pruppert

      Say I have a text field (e.g., Field1) that contains the following text:

       

      Jim's favorite colors are blue, green, yellow, burnt sienna, orange, and red.

       

      How would I define a second calculated field that returns occurrences of specific text from the first field. Pseudocode would look like:

       

      Field2 = list of any of these colors that appear in Field1 (green, burnt sienna, magenta)

       

      Returns: green, burnt sienna

       

      I've tried to use FilterValues but cannot get it to work.