stefw - profile

stefw · Mar 13, 2023

I have addresses in multiple lines and am using REGEX EXTRACT in Airtable to separate the components (street address, suburb, state, post code) before sending them on for shipping labels.I've used REGEX_EXTRACT({text input}, "^(?:.*\n){1}") to extrac...

stefw · Mar 13, 2023

Thanks Adam, you're a legend! The last line of each address is made up of the Suburb, State and Postcode.Currently I'm only extracting the postcode and then matching it against a database to find the Suburb and State. I'm doing this because I don't k...

User Statistics

User Activity

REGEX extract all text lines except for last

Re: REGEX extract all text lines except for last