- Street
- Extract only the HouseNumber and StreetName from each address in the field, removing the City, StateCode, and Zipcode. For example, from "123 Main St, Springfield, IL, 62704" extract "123 Main St".
- City
- To extract the City from addresses in the format "HouseNumber StreetName, City, StateCode, Zipcode" in the field, select the text between the first comma and the second comma. For example, in "123 Main St, Springfield, IL, 62704", the City is "Springfield".
- State
- To extract the StateCode from addresses in the format "HouseNumber StreetName, City, StateCode, Zipcode", select 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
- Zipcode