Text.Contain or List.Contain

[Einomi]

Hello

I have the following column in my table

Description

Hello AADF 456

Hello GTYH 456

Hello AADF 987

Hello GTYH 987

I would like please a M code to be able to identify the Hello, I mean I would like to have this

If my column contains Hello and 456 I want H1

If my column contains Hello and 987 I want H2

Description	Output
Hello AADF 456	H1
Hello GTYH 456	H1
Hello AADF 987	H2
Hello GTYH 987	H2

I found that Text.Contains works only for one word, here I am looking for two string of characters which may not foloow each other

I hope I was clear enough and it makes sense

Thanks All

[ronrsnfld · Accepted solution]

If you are looking for multiple words in a column, and then outputting a code, the "best" way to do that probably depends on the nature of your actual problem.

One "simple" method is with a Custom Column using List.ContainsAll:

if List.ContainsAll(Text.Split([Description]," "),{"Hello","456"}) 
   then "H1" 
   else if List.ContainsAll(Text.Split([Description]," "), {"Hello","987"}) 
   then "H2" 
   else null

However, if you have many possible combinations, using a lookup table approach might be more flexible.

[Einomi]

Hi, @AlexisOlson 

I am sorry for the delay, I did not get notifications of your answer.

If in my column [Tableau C_0. Transaction Description] we have the string "Hello" and the string "456" then H1

I am attaching a picture of my M code, I am not sure if I managed to work it out with your code

[AlexisOlson]

You could use multiple Text.Contains functions.

if Text.Contains([Description], "Hello") then
    if      Text.Contains([Description], "456") then "H1"
    else if Text.Contains([Description], "987") then "H2"
else "Other"