Print Page | Close Window

How to Show First 5 Characters? Printed From: Crystal Reports Book Category: Crystal Reports 9 through 2020 Forum Name: Report Design Forum Discription: The best way to design a report and problems you have encountered URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=20164 Printed Date: 29 Apr 2024 at 5:59am Topic: How to Show First 5 Characters? Posted By: kgbo Subject: How to Show First 5 Characters? Date 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. Replies: Posted By: DBlank Date Posted: 28 Oct 2013 at 9:37am left(table.zipcode,5)

Print Page | Close Window