How to split a string Data Item?

[jcsanson]

Hello,

I wonder if it's possible to split a string Data Item by a '|' delimiter, and after that group in the same column?

Ex.:
Current:

COLUMN(TAG)
TAG001|TAG002|TAG003

Desire:

COLUMN(TAG)
TAG001
TAG002
TAG003

We work with Cognos Version 8.4.1

Thanks,

[Bark]

I believe it is not possible to do this within Cognos. I am afraid you would need to do it in the database.

[MFGF]

Hi,

Are you asking simply for the data within the row to be formatted with the tags below each other (but still physically within the same row) or are you asking for this one row of data (with three tags) to be converted into three separate rows of data? If it's the former, you may be able to play with formatting to achieve this in the report, but the latter isn't really a reporting challenge - it's pivoting the data itself. Tools such as Cognos 8/10 Data Manager would allow you to do this quite easily, but you may not have this?

Cheers!

MF.