CSV to Columns in Cognos

[Raghuvir]

Hi All,


I have a below requirement where i have column for Security Roles which has values that are comma seperated for e.g.

A,B,C,D

i have to seperate out there values to columns i.e.

Col1   Col2  Col3  Col4
A      B     C     D

We are using  cognos 11.0.7 and Datasource is Netezza. is there any function that we can use to achieve that ?

Thanks!