Forum Discussion
Solved
Extract round figure from Text
I try using code below to extract figure from text, it works on round figure but not on float. Text.Select([TextColumn], {"0".."9"}) This is my output below. QUANTITY x 4 4 QUANTITY...
pls try this
List.Select( Splitter.SplitTextByAnyDelimiter({",", ".", " "})( Text.Select([Column1], {"1" .. "9", ",", ".", " "}) ), each _ <> "" ){0}
Rochejf , First use Text.Replace to remove QUANTITY x and the Use Text.Start to get character 1
Power BI- Power Query Conditional Replace Value- https://youtu.be/Qj2bthdusiM
Power Query - Text.Start, Text.Middle, Text.End: https://www.youtube.com/watch?v=vky4wPqm0O0
The text.start is not working.
However, I changed the type to whole number after i did the text.replace so it still somehow do the trick?