Changes

Jump to navigation Jump to search
MASSACHUSETTS 02780-7319 ('State Postcode')
'''*Other Noise: g. Special cases''' Examples: BATON, ROUGE, LA 70809-4562 (the city name 'BATON ROUGH' is separated by a comma) ST. PAUL, MIN 55133-3427 (city name 'ST. PAUL' contains a dot)
QUINCY STREETARLINGTON, VA 22217-5660 (no space between street and city name :(
 
SQL code:
CASE WHEN addrline1 ~* 'BATON[,] ROUGE[,]\s{1}LA'
THEN 'BATON ROUGE'
WHEN addrline1 ~* 'ST[.]\s{1}PAUL'
THEN 'ST. PAUL'
WHEN addrline1 ~* 'ARLINGTON[,]\s{1}VA'
THEN 'ARLINGTON'
 
'''Noise: '''
BOX 87703CHICAGO, IL 60680-0703 (no space between street and city name :(

Navigation menu