Zip code filtering now that Regex is gone?

Question

Greetings all, I was met with the nasty surprise that "Matches Regex" matching is no longer a thing in the Directory for filtering. This is a serious blow to me as 100% of my recruitment effort starts by only contacting people that live within 50 miles of our location (our research participants come in to our facility to test). I need help on formulating a workaround.

Previously I had a Regex expression that matched to the 660 Zip Codes within 50 miles of me and would run that against my Directory. It was slow but it always worked. Since that is now gone and Qualtrics does not offer any tool that allows "distance from zipcode" what do I do now? Do I create a saved filter/search that is 660 lines long? With one line for each Zipcode? Can you even have a search filter that is 660 lines long? I tried just pasting all 660 Zip codes into a "embedded data > ZIpCode > Contains >" filter but that failed (I tried it with a space between zipcodes and also tried it with a pipe "|" between Zip codes).

Ideas?

Thanks.

Kate · Accepted Answer

Oh gosh that sounds terrible. The soultion is to get some sort of new embedded data category that is just "50 Miles = yes" or "1" or whatever. I think when it comes to your old data, you're looking at a really manual process. Looking up everyone with each zipcode and adding the new category. But for any new incoming indivudals, it's just a matter of using the regex to assign it from the start on an intake form. Hopefully someone has a good brainstorm on how to do that manual process faster... !

ironspider · Answer

Thanks for the idea Kate that sounds workable. Yeah it will be a pain to update the current ten thousand entries :( but it would basically be automated going forward using your method. I guess this is where I should wonder if they're going to stop supporting Regex in forms?I suppose for the old entries I can just export the Directory, filter the contacts in Excel based on the Zip codes that are within 50 miles and then assign those filtered contacts a "yes" or "true" or "1" in the new embedded data field.The other good thing about doing it your way is that I don't have to ask the participant "Do you live within 50 miles?" since they aren't always sure or give truthful answers.

Sign up

Login to the Community

Scanning file for viruses.

This file cannot be downloaded