15.5 Parse and extract numbers


Below is a table with a column of data that is a mixture of characters and numbers. The numbers appear in multiple places irregularly:


Now we want to extract all the numbers from each row and put them in column B. The expected result is as follows:


Enter in cell B1:


Then drag B1 down to every relevant row
Use the words@d to split the string in each row to extract all numbers to form a sequence, and then use the concat to concatenate every number together.

esProc Desktop and Excel Processing
15.4 Concatenate into string
15.6 Parse and extract dates