Find contacts with erroneous ZIP codes

[GTucker]

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.

[GTucker · Accepted solution]

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

[TiphaineCuisset]

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