Extract Address and City from String

[vraman0513]

Hello - I am trying to extract the address and city from the following addresses. Could anyone help?

2718 WEST BUCKNER ROAD DALLAS, TX 75237

<colgroup><col></colgroup><tbody>
</tbody>

 

[oldbrewer]

Rick, assuming he gets all the abbrevs for ave, road etc, if it can be a 3 word city could he break at the "CA" type abbrev, but what if they wrote California in full ? I would do the easy ones automatically and mark the difficult ones for manual intervention, I think...