I've got a data set where a majority of the Address fields contains "ATTN: firstname lastname ### Address", see below, and I'm trying to only pull out the actual street address and not any of the ATTN: or names before the actual address. It seems like I'll need a RegEx/Formula Tool to help accomplish this but I'm having a disconnect on what RegEx operators to use in my expression. Any help will be greatly appreciated:
From This:
| ATTN: MATTHEW OR MARC LASTNAME 1234 WINTON ROAD |
| ATTN: RON LASTNAME 123 EAST 2ND STREET |
To This:
| 1234 WINTON ROAD |
| 123 EAST 2ND STREET |
