Extracting digits from a text string

[Giovanni_PBI]

Hi,

I'm searching for a best-practice method to solve the following problem. I'm trying to extract a 5/6 length digit from the following text string.


I want to extract the 6 length digits from the page column for each unique URL and return the result in the VacancyId column.

There are a lot of different url structures in the Page column. 

Is there a best-practice approach for this?

[Zubair_Muhammad]

@Giovanni_PBI

If these are the only numbers in the string, you can add new custom column as

=Text.Select([Page], {0..9})

[Anonymous]

Hi Zubair,

Thank you very much, that's very helpfull. 🙂

Unfortunately these are not the only numbers in the string.

The other strings look like this;


Is there a best-practice way to solve this?

[Zubair_Muhammad · Accepted solution]

HI @Anonymous

I believe the post got duplicated.

Try my solution in the post below

https://community.powerbi.com/t5/Desktop/How-to-extract-5-6-length-ID-numbers-from-a-text-string/m-p/609815/highlight/false#M290575