Do you need to sort your file by numeric street order or by street name but you can not because the street number and street name occupy the same field? Address Parser is the answer for you! It will break down each record or field into its smallest elements.
DATA ENHANCEMENT - Address Parser
BEFORE | |
---|---|
ADDRESS | CSZ |
3200 NW Ellsworth St | Los Angeles CA 90026 |
4512 Beechmont Dr | Anderson IN 46012 |
708 Alameda Dr | Huntingtown MD 20639 |
125 Campground Ln | Pilot Mountain NC 27041 |
11105 Brittsville Rd | Georgetown TN 37336 |
AFTER | ||||||
---|---|---|---|---|---|---|
ADR NR |
ADR PREFIX |
ADR NAME |
ADR SUFFIX |
CITY |
ST |
ZIP |
3200 | NW | Ellsworth | St | Los Angeles | CA | 90026 |
4512 | Beechmont | Dr | Anderson | IN | 46012 | |
708 | Alameda | Dr | Huntingtown | MD | 20639 | |
125 | Campground | Ln | Pilot Mountain | NC | 27041 | |
11105 | Brittsville | Rd | Georgetown | TN | 37336 |