This is the default Cognos behavior.

You can reconfigure the following parameters to create CSV files with commas as separators and proper carriage return/linefeed characters at the end of each line:

http://www-01.ibm.com/support/docview.wss?uid=swg21338932

Example: