Joined: 17 Apr 2009
Location: United States
Online Status: Offline
Posts: 4
Topic: Trim trailing text? Posted: 17 Apr 2009 at 12:01pm
I need to trim all text to the right of a dash(-) and can't figure out how. The trim functions seem to be for numbers only.
For example, the field will result in Special Permit-Other, Variance-Fence, Plan Review-Minor Modification. I want to only display Special Permit, Variance or Plan Review in my Crystal report.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum
IP Logged
