Crystal Reports - remove dashes in field

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
mbroad02Asked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
mlmccConnect With a Mentor Commented:
Try this

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

mlmcc
0
 
dhobaleConnect With a Mentor Commented:
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
 
mbroad02Author Commented:
Very easy to use--thank you
0
 
mlmccCommented:
Minor error in the formula

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

mlmcc
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.