Supressing Detail 2

[pineisland99]

I have a field in my db which holds state and zip data(ie - Fl 33165)

I am building a report with a field that should display zip code only. What code can I put in a formula to, say, remove the first 3 characters of my output - Ideally, my result would display only the zip code.

Thank You

 

[ssakkerm]

Use 'right' function to display only Zipcode from the value of your field:
right([yourfield],5)

sailor

 

[lbass]

If the zip code sometimes has the extension (xxxxx-xxxx), you could use:

split({table.field}," ")[2]

...assuming there is always a space in the field.

-LB