COGNOiSe.com - The IBM Cognos Community

Hi All,

The ReportNet documentation states that the CSV output generated from reports can only be "Tab-delimited" and not actually Comma-separated. I need to have the reports generated with actual comma-separated values.
Can anybody suggest a way/hack to achieve this?? Any ideas would be most appreciated.

Thanks in advance...

I don't see how you can do it from within CRN.

You can open it in notepad and replace all tabs by comma's.  :-\ If you want it automised, create a small program.

I suppose you have a basic list report.

What if you have only one column in your report.
This can be achieved by unlocking the list.
Then you drag all the fields in this column , and you manually insert a string item between all the fields.
In the String item , you put a comma.

Then when exporting this report to CSV , you have a list comma separated, and no tab at all as you have only one column.

I have not tested it, but I assume it should work.

Thanks but modifying every individual report would not work for me cause there are hundreds of reports that we are talking about.

Thanks..

I just found that, when exporting to CSV, if you open the report and save it as .csv, it opens in Notepad at comma delimited.  When you save it instead of opening, in Notepad it displays as tab-delimited.  Pretty strange.

Is it not a viable option for the users to open the report and save it as .CSV?