Extract a string from an array 1

[fumbles]

Hi All -

I am brand new to Crystal and have to extract one string from a two line array from our Progress database. When I put the field on a report a get the first line ending wiht a ";" . I have no idea how to get to the second line.

I'm using Crystal 11

The help for the ERP software states that it is a two line array.

Thanks for any help.

Steve Smith

 

[lbass]

Not sure, but try the following for the second part:

if ubound(split({table.string},";")) >= 2 then
split({table.string},";")[2]

Change the 2's to 1 if you only want the first part.

-LB

 

[fumbles]

Sorry to be so late in responding - we're fighting with an uncooperative erp implementation. Works like a charm!

Thanks again

Steve