Crystal Reports & SQL Reporting Services Training Consultants
Account Log in:
Username:
Password:
Above all, be true to yourself, and if you cannot put your heart in it, take yourself out of i
 
Unknown
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

1

vinay

16
February
if it two like dr. convert into + and cr. into - then how will do that

MAKE A COMMENT

Name *

Email Address *

Comment *

To prove you are human what is:

56 + 67 =