Hi my name is Mike I'm new to the Crystal Reports Book Forum.

I have a string field (WOStatusDetail.PartDesc) that contains the following information:

"Grade: Ti 6Al-4V Thickness: 1.750" Width: 6.500" Length: .000" Heat Treat Code: Annealed"

I need to create formulas that create the following, (the length of the text varies):
1) Grade: Ti 6Al-4V
2) Thickness: 1.750"
3) Width: 6.500"
4) Length: .000"
5) Heat Treat Code: Annealed

I have tried MID and INSTR but have failed miserably!
thanks in advance

Mike

Thanks Sastry,

The code you provided works great but the field ((WOStatusDetail.PartDesc))has to be separated into the 5 formulas that I stated above. Maybe this can be done with the code you provided but I'm really a newbie and I can't figure out how to do that.

Thanks for your help

Ok this is a continuation of this topic but with a twist.

Using the code above I get the following results:

High Temp: 1950F / Low Temp: 1760F

Apply Dim: 12 Sqr x 4.6
Pcs: 6

Forge Dim: .800" x 8.900" x 70.000"
Forge Tol: 0.070" x 0.250" x 0.125"

Mults: 4.0

Forging Instructions:
2.500 x 10.00
Reheat 1760F
1.500 x 8.90 x 6

My question: Is there a way to only extract or select the 2 lines of text that begin with:

Forge Dim:
Forge Tol:

Thanks