Split column based on any 5 digit number

Question

Hi

I have a file with address information that i need to split into separate columns

Two examples:

Sannadalsvägen 16 lgh 1002 11765 Stockholm SE

Sätersvägen 9 19267 Sollentuna SE

If I could split it based on any 5-digit number, I think i could sort the rest out.

Like this:

Column1                                             Column2

Sannadalsvägen 16 lgh 1002             11765 Stockholm SE

Sätersvägen 9                                    19267 Sollentuna SE

Is there a way to split a column based on any 5-digit number?

JosephSerpis · Accepted Answer

Hi @Fernström you can if you use Regex I have mocked up a workflow that showcases that approach. The syntax (.*?)(\d{5}.*) will first find everything up to five digits and place into one column denoted by (.*?). Then (\d{5}.*) will find five digits and place everything else after the five digits into a second column.

Fernström · Accepted Answer

Works perfect! Thank you so much!