Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Report Design
Message Icon Topic: How to Show First 5 Characters? Post Reply Post New Topic
Author Message
kgbo
Newbie
Newbie


Joined: 26 Jun 2013
Online Status: Offline
Posts: 30
Quote kgbo Replybullet Topic: How to Show First 5 Characters?
    Posted: 28 Oct 2013 at 9:36am
Hello,

I am working with a zip code field in which some are entered as
90210 and then some are entered as 90210-3413.
Some zip codes have been incorrectly entered in which they may show 90210--3413 or 90210 - 3413.

Is there a formula that will allow me to show only the first five digits?

Thank you.
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 28 Oct 2013 at 9:37am
left(table.zipcode,5)
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
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



This page was generated in 0.047 seconds.