Crystal Reports & SQL Reporting Services Training Consultants
Account Log in:
Username:
Password:
Excellence can be obtained if you care more than others think is wise, risk more than others think is safe, dream more than others think is practical, expect more than others think is possible
 
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!!!!

06
June

How Do I Extract the First Name from a Contact Field in Crystal Reports XI?

I was asked during a recent training session "How Do I Separate the First Name from the Surname in a Contact Name Field in Crystal Reports XI?"

Solution:

The delegate needed to create a letter just using the first name part of a field that held the full name.

To separate the first name from the surname within a field, one will have to use two string functions, Left and InStr.

The formula to do this is:

Left({Tablename.Fieldname},InStr({Tablename.Fieldname}," ")-1)



If you have any questions, leave us a comment below, or need any assistance, please do not hesitate to Contact Us

MAKE A COMMENT

Name *

Email Address *

Comment *

To prove you are human what is:

12 + 23 =