Forum Discussion

kb19270's avatar
kb19270
Frequent Visitor
3 years ago
Solved

undefined

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...
Need Help
  • rsbin's avatar
    rsbin
    3 years ago

    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,

rsbin's avatar
rsbin
Community Champion
3 years ago

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,