Find and extract 7 digit numbers starting with a 1 from a column containing other numbers and text

[mgp-opti]

Hi all,

Please could someone let me know how I can extract an 7 digit number that starts with a 1 from a column which contains other numbers (luckily of a different length or which don't start with a 1) and text. It would be great to separate this number and put it in to it's own column if that's possible.

Examples below. As you can see the 7 digit number appears in different places in the column. 

1002223 - 7003117328 - ID: 74526 - Attendance

1046890301 - 210438 1002515 - CW

2047074788 - 210525-1002834

1053847149 - 1016727- 212170 - cw upper

Many thanks in advance for any help.

Marcus

[Anonymous · Accepted solution]

Hi there.

I'm afraid DAX is not the right tool for this job. Please use PowerQuery. It'll be dead easy with PQ.

Best
D

[mgp-opti]

Understood - many thanks Darlove for pointing me in the right direction. Much appreciated.