Formula : Change Shipping adresse format

[Matthieu_LABERI]

Hi community, 

I'm French and when an order is generated on my Shopify, i receive the shipping adress in this format : "7 rue notre Dame" (On shopify and Airtable)
For another application, the house number (7 in my exemple) need to be at the end and not the beggining.
Do you have a formula or a solution to take the number at the beginning while whe can have 1, 2 or 3 numbers or nothing at the beggining of the shipping adress ? 

Thank's a lot for your help, 

Matthieu

[Harsh2]

Hi @Matthieu_LABERI 

You can extract the number with the help of a regex. To be more specific use the REGEX_EXTRACT function

Hope this helps!