Forum Discussion
Detect number in a text string
I want a true/false statement in Power Query to detect numbers in a text string. 45a- TRUE ab- FALSE 34- TRUE aa46- TRUE
Hi Anonymous ，
Text.contails could not work on more then one values, similar error refer:
And change yours to the below:
if Text.Contains([Product], "1") or Text.Contains([Product], "2") or Text.Contains([Product], "3") or Text.Contains([Product], "4") or Text.Contains([Product], "5") or Text.Contains([Product], "6") or Text.Contains([Product], "7") or Text.Contains([Product], "8") or Text.Contains([Product], "9") or Text.Contains([Product], "0") then "True" else "False"Did I answer your question? Mark my post as a solution!
Best RegardsLucien
Actually there is another solution if you want to make it dynamic you can use this kind of code
Let's say the name of this field is [Sample1]
45a- TRUE
ab- FALSE
34- TRUE
aa46- TRUE
Power Query code:
if List.AnyTrue(List.Transform({0..9},(NumberColumn) => Text.Contains([Sample1],Number.ToText(NumberColumn)))) = true then "TRUE" else "FALSE"
Please put thumbs up if I help you better