Solved

Crystal Reports - remove dashes in field

Posted on 2009-07-16
4
445 Views
Last Modified: 2013-11-15
I am trying to print a field on a report which has embedded "-" in it which I DON'T want to print.  is there a formula for removing embedded character??

Thanks for your help
0
Comment
Question by:mbroad02
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
4 Comments
 
LVL 101

Accepted Solution

by:
mlmcc earned 400 total points
ID: 24870879
Try this

Replace({YourField},'-',')

mlmcc
0
 
LVL 5

Assisted Solution

by:dhobale
dhobale earned 100 total points
ID: 24871733
Create a formula in formula editor as shown above by mlmcc:

Replace({YourField},'-',')

and then insert the formula field on report instead of your old field.
0
 

Author Closing Comment

by:mbroad02
ID: 31604288
Very easy to use--thank you
0
 
LVL 101

Expert Comment

by:mlmcc
ID: 24891896
Minor error in the formula

Replace({YourField},'-','')

mlmcc
0

Featured Post

On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Problem Statement In an SAP BI BO Integration project when a BO universe is built on a BEx query, there can be an issue of unit & formatted value objects not getting generated in a BO universe for some key figures. This results in an issue whereb…
Today, still in the boom of Apple, PC's and products, nearly 50% of the computer users use Windows as graphical operating systems. If you are among those users who love windows, but are grappling to keep the system's hard drive optimized, then you s…
This video Micro Tutorial shows how to password-protect PDF files with free software. Many software products can do this, such as Adobe Acrobat (but not Adobe Reader), Nuance PaperPort, and Nuance Power PDF, but they are not free products. This vide…
This is my first video review of Microsoft Bookings, I will be doing a part two with a bit more information, but wanted to get this out to you folks.

734 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question