I started with a list of street terms (Street, Avenue, DR) and did find and replace to add |s after them. I suspect there's a way to get the RegEx tool to do most of the other steps itself (output null for missing zip codes, for one) but I added extra tools instead.