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: