Hello,
I am trying to clean up a large dataset of addresses, where there are several different versions of the same address (e.g. '101 Main St' can also be listed as '101 Main Street') but they are associated with the same individual. I want to create a consolidated dataset with consistent addresses.

There are some addresses that I need to drop because they are not actual street addresses - e.g. '*103', '*Dept 164'. Many of these erroneous addresses begin with an asterisk, others with alternative symbols.
Is there a way to selectively drop those with symbology or do I need to do something like 'split address, generate (new)' and proceed from there?

Thank you!