Filtering out incorrect user input Zip Codes

I have a feeling this is very simple, but as someone who is new to Alteryx I am struggling to find a solution:

I have a Field, "Zip Code", which is full of freeform user input data, which means that anything and everything could be input - all I am trying to do is use a formula to say 'If [ZipCode] is 5 numbers then [ZipCode] OR if [ZipCode] is in this format with all numbers XXXXX-XXXX" then [ZipCode]"

Can someone help me please?

Thanks!

Help

Accepted answers

One way of doing this.

IF REGEX_Match([Zip code], "\d{5}")
THEN [Zip code]
ELSEIF REGEX_Match([Zip code], "\d{5}\-\d{4}")
THEN [Zip code]
ELSE null()
ENDIF

Many thanks

Shanker V

All comments

One way of doing this.

IF REGEX_Match([Zip code], "\d{5}")
THEN [Zip code]
ELSEIF REGEX_Match([Zip code], "\d{5}\-\d{4}")
THEN [Zip code]
ELSE null()
ENDIF

Many thanks

Shanker V

If I understand the question the other way to filter.

REGEX_Match([Zip code], "\d{5}") OR
REGEX_Match([Zip code], "\d{5}\-\d{4}")

Many thanks

Shanker V

Thank you very much, it worked perfectly!! You understood exactly what I was going for

Quick Links

Tags

This months top contributors

atcodedog05 19598

Qiu 15867

MarqueeCrew 13708

apathetichell 13703