Sample Header Ad - 728x90

How do I parse addresses in PostgreSQL?

7 votes
1 answer
7599 views
Let's say for instance that I want to parse these addresses for the Chicken Ranch Chicken Ranch 10511 Homestead Rd Pahrump, NV 89061 Chicken Ranch 1600 Pennsylvania Avenue NW Washington, D.C. 20500 In both of these cases, I'd like to get rid of Rd and Avenue. For instance in the first case, I'd like to get "Homestead", and in the second "Pennsylvania". Not every address has a designation like this though.
Asked by Evan Carroll (65532 rep)
Mar 2, 2017, 03:45 AM
Last activity: Mar 3, 2017, 04:50 PM