topic Re: Find and extract 7 digit numbers starting with a 1 from a column containing other numbers and text in DAX Commands and Tips

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

mgp-opti — Wed, 26 Feb 2020 16:44:27 GMT

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

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

Anonymous — Wed, 26 Feb 2020 17:56:16 GMT

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

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

mgp-opti — Wed, 26 Feb 2020 18:38:40 GMT

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