GM & Crystal: Function to start at a certain position

[sharvey90]

GM ver. 6.0
Crystal 8.5

My report has the "Reference" field from an Activity (Sale) and I need it to only return the data that a person would actually input NOT the customer contact information.

For example, a rep. completes a sale. When running the report it displays the "reference" field as follows:

Product A (oc: John Smith)

I don't want it to display the contact name info "(oc: John Smith)" only what was typed into the "reference" field.

I need a function similar to (Left, Right or Mid) however, I'm not sure if a function will do the trick.

Any ideas? Thanks in advance.

 

[dgillz]

wasn't the entire string "Product A (oc: John Smith)" typed into the reference field? If not what was typed in there?

Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports

http://www.trianglepartners.com

 

[sharvey90]

The only thing that was physically input into the reference field was "Product A". The "(oc: John Smith) is being picked up from whomever was listed as the "contact" in the "contact" field.

 

[dtempleton]

Something like this?

If  InStr ({Table1.Reference}, " (oc:" ) > 1 Then
    Left ({Table1.Reference}, InStr ({Table1.Reference}, " (oc:") - 1 )
Else
    {Table1.Reference}