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

Discussion created by pruppert on Jul 20, 2016
Latest reply on Jul 21, 2016 by Benjamin Fehr

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.