Extract Address and City from String

[vraman0513]

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

[TABLE="width: 425"]
<colgroup><col></colgroup><tbody>[TR]
[TD]2718 WEST BUCKNER ROAD DALLAS, TX 75237[/TD]
[/TR]
</tbody>[/TABLE]

 

[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...