Forum Discussion
Solved
Modify "Text.contain" in Power Query to look and identify exact string of text
Background: I want to create a new table column in power query. Every time the exact word "abc" is found in [TITLE], abc shall be written in the new Column otherwise N/A. Column abc abc N/A .....
Use this
if List.Contains(Text.Split([TITLE]," "), "abc") then "abc" else "N/A"
Use this
if List.Contains(Text.Split([TITLE]," "), "abc") then "abc" else "N/A"
Thank you! Seems to be working as expected.
