Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I'm trying to search a column, for a list of terms, and have any matches listed in the new column. For example, the column I want to search has a mash-up of text "AAAAAAABOBAAAAAAJOHNAAAAAAASUEAAAAA" and I want to find out which of my list of names are in the text. The list of names is {BOB, CHAD, SUE, MIKE, DON} and the result needs to be "BOB, SUE".
Solved! Go to Solution.
In a custom column, use following formula where [Text] is your column name and ListOfNames contains the names
Text.Combine(List.Select(ListOfNames, (x)=>Text.Contains([Text], x)), ", ")
In a custom column, use following formula where [Text] is your column name and ListOfNames contains the names
Text.Combine(List.Select(ListOfNames, (x)=>Text.Contains([Text], x)), ", ")