Trim a zip code to 5 characters

[ccsfdave]

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.

94101 
94102
941031514
941321600

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

[kristian_kolb · Accepted solution]

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