Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Crystal Reports - remove dashes in field

Posted on 2009-07-16
4
Medium Priority
?
452 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
  • 2
4 Comments
 
LVL 101

Accepted Solution

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

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

mlmcc
0
 
LVL 5

Assisted Solution

by:dhobale
dhobale earned 400 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

NEW Veeam Backup for Microsoft Office 365 1.5

With Office 365, it’s your data and your responsibility to protect it. NEW Veeam Backup for Microsoft Office 365 eliminates the risk of losing access to your Office 365 data.

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…
Hi, In my previous Article  (http://www.experts-exchange.com/Database/Reporting/A_15199-Introduction-to-Microstrategy.html)I discussed some basic understanding of Microstrategy that how we can get in Intro of Microstrategy (MSTR). Now it's tim…
Despite its rising prevalence in the business world, "the cloud" is still misunderstood. Some companies still believe common misconceptions about lack of security in cloud solutions and many misuses of cloud storage options still occur every day. …
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…

876 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