Power Query - extract maximum decimal from a string

Question

Hi all!&nbsp;I need some help extracting a maximum decimal value from a string.&nbsp;The data looks something like this:Text 0.5-1.5textText 0.5 to 1.5 text1.54.562.460.123textText 3.25 text&nbsp;Thanks in advance!Laura

v-frfei-msft · Answer

Hi&nbsp;Loz123,
&nbsp;
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&nbsp;extracting numbers from a string, you can refer to that to change your data.
&nbsp;
Regards,
Frank

thejeswar · Answer

Hi&nbsp;Loz123&nbsp;&amp; v-frfei-msft,As per the link provided by&nbsp;v-frfei-msft, I am able to extract numbers from the string.&nbsp;Below is the screenshot&nbsp;&nbsp;&nbsp;

loz123 · Answer

Thanks&nbsp;Thejeswar. Not quite what I am looking for - I would like to extract the largest decimal number from a string.&nbsp;Any more ideas would be really appreciated!

Forum Discussion

Power Query - extract maximum decimal from a string

3 Replies

Related content

Running Maximum

Extract Data from sharepoint

Decimal Precision

Extracting Maximum number in string

Rows - Maximum Date