If every description contains the "(" in it, then you can create a Function in place of the part.partdescription on your labels. The function will be one line as follows:

left({part.partdescription},instr({part.partdescription},"(")-1)

HERE'S what the above line does...
---leaves only the part of the description to the left of the "("

instr({part.partdescription},"(")
---returns the position of the "(" in the string.

The InStr (str1,str2) function returns the position of the first occurrence of one string within another. This position is a 1 based index of the characters in str1. If str2 is not found in str1, the InStr function returns 0.

the LEFT(Str,Length) function obtain a certain number of characters from the left end of a text string. For instance, you could use the Left function to obtain just the area code from the values in a field containing phone numbers.

----- Original Message -----
From: Cole, Dave
To: eManfacturing Yahoo Groups (E-mail)
Sent: Tuesday, May 01, 2001 2:00 PM
Subject: [Vantage] Crystal Reports.

Hi,

I need some help with Crystal Reports.

In the Part Master we use the Part Number field for out part number and the
Description field for the Customer Part number.

For example:
Part: 2400-055
Description: L47746P01 (Shaft, Aft, - Low Pressure Turbine Rotor)

All our parts are entered this way. I would like to be able to extract just
the first part of the description up to but not including the "(" to print
on some labels.

Thanks,

Dave Cole
Reeder & Kline

[Non-text portions of this message have been removed]

Yahoo! Groups Sponsor

To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please go to: http://groups.yahoo.com/group/vantage/files/. Note: You must have already linked your email address to a yahoo id to enable access.

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.

[Non-text portions of this message have been removed]