Remove space and Characters

Question

Hi All,

I have the below addresses and like to transform them as in the Required Output column.

Address Required Output
1/1-3 Carboni Street11-3carboni St13/51-53 Cairds Avenue1351-53cairds Ave1/127 Humphries Road1127humphries Rd1 Badger Place1badger Pl10 Walpole Crescent10walpole Cres

Regards,

Jag

MarqueeCrew · Accepted Answer

Regex_replace(address,"\d\s",'\d')

That might work for you.  But you will need to create a list of types and their replacements. Use a find and replace to change PLACE with PL as an example.