Hi,
I have a table that has a column of comments that can contain more than one 8 digit number. For every value in this column I need to pull every 8 digit number that is there, often separated by varying delimiters or no delimiter at all with inconsistencies in the data, but the number will always contain 8 digits, and will always start with a 3 or 4, never start with any other number.
How would I do this in power query to put values that have more than one 8 digit number in one cell with a comma delimiter which I can then use to split into rows? See below for a few examples of what I would like the result to be for multi 8 digit numbers with the "comment" column on the left, and resulting column on the right.
46353865 = 46353865
Line 137 = null
31540572_46403933_31597936 = 31540572,46403933,31597396
35544223 and 35601630 = 35544223,35601630
I have a table that has a column of comments that can contain more than one 8 digit number. For every value in this column I need to pull every 8 digit number that is there, often separated by varying delimiters or no delimiter at all with inconsistencies in the data, but the number will always contain 8 digits, and will always start with a 3 or 4, never start with any other number.
How would I do this in power query to put values that have more than one 8 digit number in one cell with a comma delimiter which I can then use to split into rows? See below for a few examples of what I would like the result to be for multi 8 digit numbers with the "comment" column on the left, and resulting column on the right.
46353865 = 46353865
Line 137 = null
31540572_46403933_31597936 = 31540572,46403933,31597396
35544223 and 35601630 = 35544223,35601630