- Street
- To extract just the "HouseNumber StreetName" from addresses in the format "HouseNumber StreetName, City, StateCode, Zipcode", use the text before the first comma. For example, from "123 Main St, Dallas, TX, 75201", extract "123 Main St".
- City
- Dallas
- State
- To extract the StateCode from the address in the field "Sidewalk on Aldine, Driveway on Skillman," identify the two-letter code that appears before the Zipcode. For example, in "123 Main St, Dallas, TX, 75201," the StateCode is "TX."
- Zip
- To extract the Zipcode from an address in the format "HouseNumber StreetName, City, StateCode, Zipcode", use the following formula in Airtable:
```
RIGHT({Sidewalk on Aldine, Driveway on Skillman}, 5)
```
This assumes the Zipcode is always the last 5 characters of the address.