I am attempted to set a variable via an Alter Format where a data column matches specific format (in this particular case, a 9 digit zip code where the first 5 characters are digits, then a hyphen, then four digits).

I am not getting the match I expect using this code, please advise:

CASE (
( Length( the_column ) = 10 ) AND ( matches( '\d\d\d\d-\d\d\d\d\d', the_column)),
'is_9digit_USzipcode',

'is_not_9digit_USzipcode'
)

Thank you-
-Kurt

This message has been edited. Last edited by: FP Mod Chuck,

Take a look at the REGEX function.

REGEX documentation