Forum Discussion
Detect number in a text string
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
I'm sorry but the code is just too complex for me to understand. I find it easier to add a condition with true conditions being every number from 1-9, see below:
However a single line code would be easier to manage. Somtehing like this:
text.Contains([Product], type number)
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]