Airtable Sync App

Personal Info

Street: To extract just the "HouseNumber StreetName" from the address in the field [email protected], use this formula in Airtable: ``` LEFT({[email protected]}, FIND(",", {[email protected]}) - 1) ``` This will return only the part before the first comma, which is the "HouseNumber StreetName".
City: To extract the City from the address in the field "[email protected]", use this formula in Airtable: ``` TRIM(MID({[email protected]}, FIND(",", {[email protected]}) + 2, FIND(",", {[email protected]}, FIND(",", {[email protected]}) + 1) - FIND(",", {[email protected]}) - 2)) ``` This will return the City portion of the address.
State: To extract the StateCode from the address in the field [email protected], use this formula in Airtable: ``` TRIM(MID({[email protected]}, FIND(",", {[email protected]}, FIND(",", {[email protected]}) + 1) + 2, 2)) ``` This will return the two-letter StateCode from the address.
Zip: To extract the Zipcode from the address in the field [email protected], use this formula in Airtable: ``` TRIM(RIGHT({[email protected]}, 5)) ``` This assumes the Zipcode is always the last 5 characters of the address.