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?


      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.