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
|
