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]
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]