Crystal Reports & SQL Reporting Services Training Consultants
Account Log in:
Discover what you really want, by looking at what you envy in others
Institute of IT Trainers - Freelance Trainer of the Year 2006 & 2009
Liverpool Business Connect Member
  Maximum Impact Solutions Limited - Reporting Solutions, Creating Answers
Reporting Solutions - Creating Answers, Crystal Reports, Dashboarding (Xcelsius) & SQL Reporting Services

The Maximum Impact Solutions Blog Feed ME!!!!


How Do I Replace the Dashes with Spaces in a field in Crystal Reports?

During a recent Crystal Reports XI training course I was asked "How do I replace the dashes with spaces in the phone field?"


In Crystal Reports 7.0 - 2008, to replace one set of characters with another set of characters,  one can use the Replace function.

To replace the dashes with spaces in the field, one can use the following formula:

Replace ({Tablename.FieldName}, "-", " ", 1, -1, 1)

If you have any questions, or need any assistance, please do not hesitate to
Contact Us


Name *

Email Address *

Comment *

To prove you are human what is:

32 + 30 =