trevorg826

Mass partial address matching

Discussion created by trevorg826 on Jan 15, 2020

Hello all, I've got a question.

 

I am attempting to find a way to mass match customer points and county parcel address' to each other. the issue is that the customer point address fields are usually in a " 123 JOHN WAY" but the county parcel address fields are in " 123 JOHN WAY NEW YORK NY 10001 ####"

 

is there a way to quickly match up to say, 100 customer ADDRESS to county parcel ADDRESS and give me/ select the parcels that have customers while disregarding the parcels that do not have active customers?

Outcomes