Lists, Lead Scoring & Workflows

GTucker
Participante

Find contacts with erroneous ZIP codes

resolver

Is there a way to find all contacts whose postal code (which the person entered on a form) is NOT a five-digit entry? This business only sells in the US.

 

I am auditing a database that has entries where the person has entered a question (no clue why anyone would do that), or their name instead, or they have a non-US postal code or just plain gibberish.

 

I need a strategy for finding these erroneous entries. I need to purge them.

0 Me gusta
1 Soluciones aceptada
GTucker
Solución
Participante

Find contacts with erroneous ZIP codes

resolver

Thanks @TiphaineCuisset but I ended up exporting the data and did a manual cleanse. 

Ver la solución en mensaje original publicado

0 Me gusta
2 Respuestas 2
GTucker
Solución
Participante

Find contacts with erroneous ZIP codes

resolver

Thanks @TiphaineCuisset but I ended up exporting the data and did a manual cleanse. 

0 Me gusta
TiphaineCuisset
Administrador de la comunidad
Administrador de la comunidad

Find contacts with erroneous ZIP codes

resolver

Hi @GTucker 

 

Thank you for reaching out.

 

I want to tag some of our experts here - @Mike_Eastwood @jforte @himanshurauthan do you have any suggestion for @GTucker on this? 

 

Thank you!

Best

Tiphaine


Saviez vous que la Communauté est disponible en français?
Rejoignez les discussions francophones en changeant votre langue dans les paramètres !

Did you know that the Community is available in other languages?
Join regional conversations by changing your language settings !