Extract from a column with free text when a 10-digit number is found in a row

[Syndicate_Admin]

Good

I need help to know how I can extract in power query from a column that contains free text , which can have text figures or expecial characters every time a number of 10 digits is found that are followed . These 10 figures in a row can be in any position and are not accompanied by any index or similar.

An example would be this. My NEW COLUMN would only have to return me when in the free text column you find 10 numbers in a row

Is it possible to do it without knowing M, using in power query ?.. I have tried to do it by inserting column from examples but being so many different the possibilities do not find a pattern.

I know that in sql with the function REGEXP_EXTRACT(FREE_TEXT, "[0-9]{10}") it could be done, but I tried the same formula in power query without satisfactory results

Thanks in advance

[v-xiaotang · Accepted solution]

Hi @Syndicate_Admin 

Here is a similar solution for your reference, will it help?

Solved: Extract 5 Consecutive Numbers from Text String - Microsoft Power BI Community

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.