Airtable Sync App

Personal Info

Street: Sure. Please provide the address, and I will extract the HouseNumber StreetName part for you.
City: To extract just the City from the address in the format "HouseNumber StreetName, City, StateCode, Zipcode," select the second item after splitting the string by commas. For example, if the address is "123 Main St, Denver, CO, 80202," the City is "Denver."
State: CO
Zip: To extract just the Zipcode from the address in the format "HouseNumber StreetName, City, StateCode, Zipcode", use the following formula in Airtable: RIGHT({39.147379812859484, -104.91557257790004}, 5)

Street: To extract the "HouseNumber StreetName" from addresses in the format "HouseNumber StreetName, City, StateCode, Zipcode," take the substring before the first comma. For example, from "123 Main St, Denver, CO, 80202," extract "123 Main St."
City: To extract the City from addresses in the format "HouseNumber StreetName, City, StateCode, Zipcode", select the second item after splitting the address by commas. For example, in "123 Main St, Castle Rock, CO, 80104", the City is "Castle Rock".
State: To extract the StateCode from an address in the format "HouseNumber StreetName, City, StateCode, Zipcode", use the following formula in Airtable: ``` TRIM(MID({39.147379812859484, -104.91557257790004}, FIND(",", {39.147379812859484, -104.91557257790004}, FIND(",", {39.147379812859484, -104.91557257790004})+1)+2, 2)) ``` This will return the two-letter StateCode.
Zip: To extract the Zipcode from the address in the field "39.147379812859484, -104.91557257790004", use a formula that finds the last 5 digits in the address string. In Airtable, you can use: `RIGHT({39.147379812859484, -104.91557257790004}, 5)` This assumes the Zipcode is always the last 5 characters in the address.