Thanks Vic,
That did it. I had tried 13 but something else must have been amiss...
Regards,
- Neil
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Vic Drecchio
Sent: Tuesday, 5 February 2013 12:25 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] 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%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf Of
nbuckman@...<mailto:nbuckman%40ymail.com>
Sent: Monday, February 04, 2013 1:55 AM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.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<http://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<http://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]
Notice:This e-mail and any attachments are confidential and are only for the use of the person to whom they are addressed. If you are not the intended recipient please advise the sender by return e-mail and delete the message and any attachments. Any use, interference with, disclosure or copying of this message or any attachments is unauthorised and prohibited. The sender does not warrant that the information is free of a virus or any other defect or error, and any views expressed herein, unless specifically indicated otherwise, are those of the individual sender.
The DH Gibson Group of Companies - http://www.gibsonshopfitters.com.au
P Please consider our shared environment before printing this communication.
[Non-text portions of this message have been removed]
That did it. I had tried 13 but something else must have been amiss...
Regards,
- Neil
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Vic Drecchio
Sent: Tuesday, 5 February 2013 12:25 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] 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%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf Of
nbuckman@...<mailto:nbuckman%40ymail.com>
Sent: Monday, February 04, 2013 1:55 AM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.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<http://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<http://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]
Notice:This e-mail and any attachments are confidential and are only for the use of the person to whom they are addressed. If you are not the intended recipient please advise the sender by return e-mail and delete the message and any attachments. Any use, interference with, disclosure or copying of this message or any attachments is unauthorised and prohibited. The sender does not warrant that the information is free of a virus or any other defect or error, and any views expressed herein, unless specifically indicated otherwise, are those of the individual sender.
The DH Gibson Group of Companies - http://www.gibsonshopfitters.com.au
P Please consider our shared environment before printing this communication.
[Non-text portions of this message have been removed]