undefined

Question

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)&nbsp; 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&nbsp;Column A&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Column BGeneral wear&nbsp; replace part&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;General wear&nbsp; &nbsp; &nbsp; &nbsp;Contamination oil drop found&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Contaminationvaccuum clean&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; -other machine moved&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; other&nbsp; &nbsp;contamination dropped oil&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; contamination

rsbin · Accepted Answer

kb19270 ,
You are right to use CONTAINSSTRING, but combined with the SWITCH function.&nbsp; 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,

Forum Discussion

undefined

1 Reply

Related content

undefined

undefined

undefined

undefined

undefined