Forum Discussion
Text.Contain or List.Contain
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
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 nullHowever, if you have many possible combinations, using a lookup table approach might be more flexible.
3 Replies
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"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
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 nullHowever, if you have many possible combinations, using a lookup table approach might be more flexible.
