Forum Discussion
Power Query - extract maximum decimal from a string
Hi all! I need some help extracting a maximum decimal value from a string. The data looks something like this: Text 0.5-1.5text Text 0.5 to 1.5 text 1.5 4.56 2.46 0.123text Text 3.25 text ...
Hi Loz123,
Based on my test, I cannot extract numbers from this kind of string and there is no work around for that. There is a case about extracting numbers from a string, you can refer to that to change your data.
Regards,
Frank
Hi Loz123 & v-frfei-msft,
As per the link provided by v-frfei-msft, I am able to extract numbers from the string.
Below is the screenshot
