How do you select the first occurrance/entry in an array field?

[rji1124]

Hi.. we are on CR 9.2... running reports from Peregrine Service Center DB...

We have an array field called assignment history in Service Center - this field keeps track of all the department names a ticket has been assigned to...

We want to extract the first element in this array and put it on a report..

Tried researching some in the resources we have, but the best we can do is pull the first letter off using a formula: [{probsummarym1.assignment.history}][1]

Any help would be greatly appreciated...

 

[synapsevampire]

How is the array delimited, or is it?

Crystal doesn't recognize any array types that I'm aware of, so you need to describe what Crystal considers the field type, and show example contents.

If it's delimited by a character, such as a pipe symbol (|), try:

split({table.field},"|")[1]

the "|" would change depending upon what you have as the delimiter.

-k

 

[rji1124]

Thanks.. this is what I need I believe... next hurdle is to figure out what exactly the delimiter is... looking at the field through Crystal, there are two very bold bars (||) between elements - perhaps a carrriage return...

 

[synapsevampire]

Those are probably pipes, try my formula using both.

split({table.field},"||")[1]

-k