Extracting digits from a text string

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?