Extract certain information from a string

[woodyinoz]

Hi all,

I am using Crystal Reports 9.

I am looking to extract some information from the middle of a string field. The field alwys follows the following layout although the number of characters may differ.

884-007-P38-A34_A35

I want to return P38.

Another example would be 881-201B-M132-A34A_B34C where I would want to return M132.

Can anyone help with this?

Thanks in advance,

Woody

 

[bdreed35]

Try this:

split({table.field},"-")[3]

~Brian

 

[lbass]

If the rule is that the characters always follow the second hyphen, then try:

split({table.string},"-")[3]

-LB