Forum Discussion
Solved
Looking for a specific formula
I am drawing a blank and I know if it is possible, that it is probably a easy answer. I have a table with over 1000 rows and each row has hundreds of columns. I want to add a forumla in the last co...
Hi RobKay12 ,
if you add column with this formula, you will get a match for each substring:if Text.Contains(Text.Combine(List.Transform(Record.FieldValues(_), (l)=> Text.From(l)), " "), "myWord") then 1 else nullif you are only interested in full matches, you need to use this formula:
if List.Contains(Record.FieldValues(_), "myWord") then 1 else null
