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...
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...
