Solved: Trim a zip code to 5 characters

ccsfdave · ‎05-03-2013

This has to be an easy answer...I am just not seeing it or it is just a warm Friday and my brain is asleep.

I have a column of results with zip codes e.g.

I want to cut out the last 4 characters (if they exist). So all the results are 5 characters only

kristian_kolb · ‎05-03-2013

if your zip codes are in a field called ZIP, that could be done by

your base search | eval SHORT_ZIP = substr(ZIP, 1,5) | ...

/K

kristian_kolb · ‎05-03-2013

if your zip codes are in a field called ZIP, that could be done by

your base search | eval SHORT_ZIP = substr(ZIP, 1,5) | ...

/K

Trim a zip code to 5 characters