- Street
- To extract just the "HouseNumber StreetName" from the "Sanethere" field, use this formula in Airtable:
```
LEFT({Sanethere}, FIND(",", {Sanethere}) - 1)
```
This will return everything before the first comma, which is the "HouseNumber StreetName".
- City
- To extract the City from the "Sane" field (formatted as "HouseNumber StreetName, City, StateCode, Zipcode"), use this formula in Airtable:
```
TRIM(
MID(
Sane,
FIND(",", Sane) + 1,
FIND(",", Sane, FIND(",", Sane) + 1) - FIND(",", Sane) - 1
)
)
```
This will return just the City portion from the address.
- State
- To extract the StateCode from the "Sane" field, identify the two-letter code that appears after the city and before the zipcode. For example, in "123 Main St, Springfield, IL, 62704", the StateCode is "IL".
- Zip
- To extract the Zipcode from the "Sane" field, use this formula in Airtable:
```
RIGHT(Sane, 5)
```
This assumes the Zipcode is always the last 5 characters of the address.