undefined

[kb19270]

I have a column in a table which contains text. I would like to create another column from this which will show a text (i have 3 text that i want to find)  if any of these texts is found in the other column and blank if it doesn't contain any of the 3 texts. I am guessing contain or containstring function should do but not sure how.

Please see example below

Column A                                                               Column B

General wear  replace part                                   General wear       

Contamination oil drop found                             Contamination

vaccuum clean                                                        -

other machine moved                                            other   

contamination dropped oil                                  contamination

[rsbin · Accepted solution]

@kb19270 ,

You are right to use CONTAINSSTRING, but combined with the SWITCH function.  Acts very much like a nested IF, but much easier to use and read:

ColumnB = SWITCH(
              TRUE(),
              CONTAINSSTRING( [Column A], "General wear" ), "General wear",
              CONTAINSSTRING( [Column A], "Contamination" ), "Contamination",
              CONTAINSSTRING( [Column A], "other" ), "other",
              "-" )

Trust you will be able to make this work for you.

Regards,