Extract field value and put in another column

[paulb1]

Hi All,

I have a multi value picklist of ethnicities.  I'd like to search for records that contains the value 'Hispanic/Latino' and move the value to a column of it's own.  Is this possible?

Thank you!

Paul

[Kenda · Accepted solution]

Hey @paulb1! If you use a Formula tool, creating a new column, with the following expression:

iif(contains([Field1],"Hispanic/Latino"),[Field1],null())

the new column will be null if the phrase was not found and the phrase otherwise. Hope this helps!

[paulb1]

Hi BK,

Thanks for the formula.  That's super close to what I need.  The new field is populating, but with more information that what I need.  Some of the fields have multiple ethnicities, for example,

Hispanic or Latino/Latina;White/Caucasian;Hawaiian Native or Pacific Islander

White/Caucasian;Black or African American;Hispanic or Latino/Latina

I'm hoping to be able to extract only the Hispanic or Latino/Latina value and write it to the new field.  The original field can stay the same.  I've replaced the second field reference with the "Hispanic or Latino/Latina" value.  Running now...

Paul

[paulb1]

That worked.  Thanks again for the formula!!!!