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.