Power Query - extract maximum decimal from a string

[Loz123]

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

Thanks in advance!

Laura

[v-frfei-msft]

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

[Thejeswar]

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

[Loz123]

Thanks @Thejeswar. Not quite what I am looking for - I would like to extract the largest decimal number from a string.

Any more ideas would be really appreciated!