pruppert

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.

Outcomes