Splitting string by particular words

[kwirky]

Hello,
I have a string which can vary in length and I need to split it so that it only shows particular data based on certain words.

Below is an example of the string.

Description
G100K5 4/0 660x920
100gsm Laserbond .
4 colour process both sides.
900 X 640.

MATCHED TO PROOF: this is a test of the PROOF wording

REPRINT: This is a test of the REPRINT wording

I want to show only the details if they are

MATCHED TO PROOF: this is a test of the PROOF wording

or

REPRINT: This is a test of the REPRINT wording

Sometimes neither of these two lines will be entered by the user, sometimes one or the other, or sometimes both.

I need to show any occurances of the above two lines only.

This is stored in a table called EstDescription.description.

I am using CR2008.

Thank you

 

[IdoMillet]

You probably need to use the Instr() function. See online help...

hth,
- Ido

view, export, burst, email, and schedule Crystal Reports.

http://www.MilletSoftware.com