I am looking for clean wat to parse street addresses

[lawlerpat]

I will have the full street address in a database field and need to break it into 3 pieces
street #
street name
street type (comparing it against a pre defined list of types. street - st, road = rd and so on)

Thanks

 

[eramgarden]

Look into charindex and i think substr examples.

 

[MichaelRed]

I have attempted this (or variations on the theme) several times w/o clear success. Typical issues are :
[tab]The format of of the fields. especially the street # field, as it may include and "Apt" number which is easily confused with other elements (street (e.g. North 32nd Ave)
[tab]Additional Lines(for Suite number)
[tab]Inclusion of "Attn: [name]".

I was able to use a standard parseing approach to get ~~ 80% of the work done and at least identify ~~ 15% of the ones which did not fit the pattern(s). Pleas not that this leave ~~~ 5% which did not get marked as non-conforming, but were also not processed correctly. These, to complete the task had to be found through a manual review and correction of the ENTIRE set. That was only a chore for a recordset of 1K or so of records, but a huge task for 100K records.



MichaelRed
m.red@att.net

Searching for employment in all the wrong places