Parse Address using RegEx

Question

Hello,

I have addresses that are both numeric and text, as well as some that are only text. How can I break this down so that I have numbers in one field and text in the other? And how do I put "Virtual" in the same column as "Highlands Pkwy SE" and so on? How do we also account for streets with numeric data? Is this doable? Can someone provide the RegEx expression to achieve this?

Thank you

DataNath · Accepted Answer

Hey @JennyRuns24, is this how you want them split? Or do you want the streets with numeric parts handled differently?

binu_acs · Accepted Answer

@JennyRuns24 One way of doing this