Skip to Content
0
Former Member
Jun 06, 2011 at 01:08 AM

Extracting data from a string

32 Views

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.

DescriptionG100K5

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 😊