Splitting the Part Description in Crystal

Neil, Assuming you have a carriage return in your PartDescription; for
example:

"Ravens win the

Superbowl!"



Then this should work: split({Part.PartDescription}, CHR(13) ) [1]



Should return: "Ravens win the "





From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
nbuckman@...
Sent: Monday, February 04, 2013 1:55 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Splitting the Part Description in Crystal...






Can anyone advise me how to extract just the first line of the Part
Description in a Crystal report?

Is is something like:

split({Part.PartDescription},???,1)[1]

but I can't figure out the delimiter...

- Neil

9.05.700C and Crystal 2011.



No virus found in this message.
Checked by AVG - www.avg.com
Version: 2012.0.2238 / Virus Database: 2639/5579 - Release Date: 02/03/13




-----
No virus found in this message.
Checked by AVG - www.avg.com
Version: 2012.0.2238 / Virus Database: 2639/5579 - Release Date: 02/03/13

[Non-text portions of this message have been removed]
Can anyone advise me how to extract just the first line of the Part Description in a Crystal report?

Is is something like:

split({Part.PartDescription},???,1)[1]

but I can't figure out the delimiter...

- Neil

9.05.700C and Crystal 2011.