Print Page | Close Window

Finding specific info in text field

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Technical Questions
Forum Discription: Formulas, charting data, Crystal syntax, etc.
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=7294
Printed Date: 04 May 2024 at 8:07pm


Topic: Finding specific info in text field
Posted By: Danish
Subject: Finding specific info in text field
Date Posted: 06 Aug 2009 at 7:21pm
Hi,
 
 
I have a field called StudentEmergencyName
The name can either be a single name like 'Mr J Edgar' or a couple eg
'Mr J Edgar and Mrs M Jones' or Mr J and Mrs M Jones'
I need to find out which of these 3 versions it could be and then based on this I need to strip out the names into either one or two.
 
This is so I can use the end result to search for an ID for each individual.
 
Need to do this because there is no relationship between the two tables I need to link together to get other information, except through the name.
 
Any ideas what formaula I can use to do the first part of stripping out the names?
 


Replies:
Posted By: Thunter
Date Posted: 07 Aug 2009 at 10:08am
If your formatting is consistend with the "and" in there, you could search the string for it and then use the "split" function to take either side of the "and".

-------------
Terry W Hunter


Print Page | Close Window