Add character in string before first number occurrence

[luismorales]

Hi All,

I'm cleaning up addresses and I need to add a comma and a space before and after each set of numbers i.e.

Av. El Parque 4160 Piso 5  needs to be 

Av. El Parque, 4160, Piso 5

This is not always the case, heres a piece of my dataset

Av. Santa Maria 2474, Providencia

Los Carreras 444, Melipilla

Rosario Norte 407, Piso 13, Las Condes

Huérfanos 670

La Concepción 332, Piso 7

So the thing is, sometimes there are 3 number characters with a comma at the end, also sometimes there are 4 number characters with a comma at the end and sometimes there are no commas.

Is there a way to do this using regex or should I just star making a Find and Replace table.

Thanks!

[DataNath]

Hey @luismorales, this works with your example as you mentioned it's needed when there are 3/4 numbers but I'd check it with a larger dataset and see if any issues come up that may need to be addressed with other logic etc:

[FinnCharlton · Accepted solution]

Hi @luismorales , this Regex works for your given examples:

[luismorales]

@FinnCharlton , @DataNath. thank you very much both approaches worked.