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
Your conditional column approach does deliver a single line of code (and is way simpler than my suggestion! )
= Table.AddColumn(#"Renamed Columns", "Number?", each if Text.Contains([Product], "1") then true else if Text.Contains([Product], "2") then true else if Text.Contains([Product], "3") then true else if Text.Contains([Product], "4") then true else if Text.Contains([Product], "5") then true else if Text.Contains([Product], "6") then true else if Text.Contains([Product], "7") then true else if Text.Contains([Product], "8") then true else if Text.Contains([Product], "9") then true else if Text.Contains([Product], "0") then true else false)
However, I can't get the code to work properly, I keep getting an error
It shouldn't return an error. Is the Product column set as type Text?
Yes it's set as Text. I get an Expression. Error. Not possible to convert the type Type to type Text.
Information:
Value=[Type]
Type=[Type]