How do I parse street address with 4 parts #,Dir,Street,Type

[CUserM]

I WORK IN AN AREA WHERE ADDRESSES HAVE A DIRECTION AS WELL AS #, STREET NAME,
AND STREET TYPE. GIVEN THERE'S NO "MIDDLE", HOW DO I PARSE THE DIRECTION?

 

[Dale Fye]

Parsing addresses is a pain in the a$$.

Can you give us a couple of examples?

Generally, I use the Split function to parse the addresses into segments,
then review each segment for certain patterns to determine whether it is the
Street#, street name, street type, direction, apt/unit #.

If the address doesn't fit neatly into my predetermined structure, I
generally process them one by one. This is VERY time consuming, but if you
build a form and use keyboard shortcuts, you can parse each address
relatively quickly.