How to add a dash to SOME zip codes only

Question

Hello. I am trying to add a dash to the zip codes with a length of more than 5 NUMERIC characters only. Also, I have zip codes of 6 characters (letters and numbers) that I am not looking to edit. Can somebody please help me with a formula that meets those conditions?

Zip codeResult98604485098604-4850799367993656465426256465-4262R2X1G7R2X1G7

Thank you

DataNath · Accepted Answer

Hey @vmirand, there's a few ways to go about this - here's what I've quickly put together:

Formula expression:

IF REGEX_Match([Zip code], '\d{6,}')
THEN REGEX_Replace([Zip code], '(.{5})(.*)', '$1'+'-'+'$2')
ELSE [Zip code]
ENDIF

Without RegEx you could use standard functions to do something like:

IF Length([Zip code]) > 5 AND IsInteger([Zip code])
THEN Left([Zip code], 5) + '-' + Right([Zip code], Length([Zip code])-5)
ELSE [Zip code]
ENDIF