NEED HELP FOR EXTRACT ONLY NUMBERS

[FabrPrado]

Hi, Good day for All

I need more one help:

How to extract only numbers from a column

|column that I have          | column that I need

There is no default, numeric characters can be anywhere in the text

[TomMartens · Accepted solution]

Hey,

in the Query Editor  add a custom column and use this formula

Text.Combine(List.RemoveNulls(List.Transform(Text.ToList([Column1]),each if Value.Is(Value.FromText(_), type number) then _ else null)))

replace Column1 with the name of your column.

The idea, put the text of the source column to a list of characters, check each character if it is of type number, if yes keep it, else skip the character.

It's maybe not that obvious, but it's the pattern how regex would do it.

A little picture of my sample

Regards

Tom