Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Formula : Change Shipping adresse format

Topic Labels: Formulas
530 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Matthieu_LABERI
6 - Interface Innovator
6 - Interface Innovator

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

1 Reply 1
Harsh2
6 - Interface Innovator
6 - Interface Innovator

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!