Parsing out a string 1

[McFly77]

Hi all,

I'm a complete newbie in the Crystal and wondering if someone could help me. I have a field that i need to parse out, unfortunately it is of variable length and content, but the format is the same.

example:

Product(s) : (07 Puzzlemania Activity Bulk 687,950) ;3rd Party Ship/Focus Logistics

Desired Result:

07 Puzzlemania Activity

The field will always start with

Product(s) : (

then list what i'm looking for, and end with either "Bulk" or "Samples"

there may or may not be info in the "3rd Party Ship" area

 

[pmax9999]

Hi McFly77

Assuming uou want everything after the second '(' and finishing before the word 'Bulk' or 'Samples', create this formula:

// Parse Formula
If Instr({table.field}, 'Samples') <> 0
Then Mid({table.field}, 15, (Instr({@table.field}, 'Samples')-15))
Else
If Instr({table.field}, 'Bulk') <> 0
Then Mid({table.field}, 15, (Instr({table.field}, 'Bulk')-15))



Cheers
Pete

 

[McFly77]

Thank You Pete! Works perfect!

Marty