Crystal Reports & SQL Reporting Services Training Consultants
Account Log in:
Username:
Password:
Don't burn bridges. You'll be surprised how many times you have to cross the same river
 
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!!!!

27
April

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?"


Solution:

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

MAKE A COMMENT

Name *

Email Address *

Comment *