Displaying array variant fields from Snowflake DB in Cognos CSV report

[neetw]

Hi,
By default the cognos csv report is tab delimited. Is there any way in which the delimiter can be changed on report levels to either comma or pipe delimited?

I have an array variant field in the database which looks like {"key1":"value1","key2":"value2"} . When i create a csv report with this field, it shows up as "{""key1"":""value1"",""key2"":""value2""}"

Is it possible to have it displayed as {"key1":"value1","key2":"value2"} in the csv report?


Thanks,
Neet