COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => COGNOS 8 Administration => Topic started by: Kahunamaxx on 28 Feb 2012 10:06:29 AM

Title: Export CSV as tab-delimited Files
Post by: Kahunamaxx on 28 Feb 2012 10:06:29 AM
Hi guys - how's it going?

Although I've read a lot of forum posts that say that Cognos exports CSV files as tab-delimited files - it actually appears that they are exported as comma delimited files.

Is there a way that I can change this setting to actually be tab-delimited?

thanks much!
Title: Re: Export CSV as tab-delimited Files
Post by: RobsWalker68 on 28 Feb 2012 10:14:14 AM
Hi,

Tab is the default so have a look at the environment settings for your system to see if it is being overridden.

Below is a link to more details:

http://publib.boulder.ibm.com/infocenter/c8bi/v8r4m0/index.jsp?topic=/com.ibm.swg.im.cognos.ug_cra.8.4.0.doc/ug_cra_id29876CSVPropertiesandValues.html

Specifically you are looking for the parameter: RSVP.CSV.DELIMITER

Rgds

Rob
Title: Re: Export CSV as tab-delimited Files
Post by: Grim on 29 Feb 2012 07:06:18 AM
Quote from: RobsWalker68 on 28 Feb 2012 10:14:14 AM
Hi,

Tab is the default so have a look at the environment settings for your system to see if it is being overridden.

Below is a link to more details:

http://publib.boulder.ibm.com/infocenter/c8bi/v8r4m0/index.jsp?topic=/com.ibm.swg.im.cognos.ug_cra.8.4.0.doc/ug_cra_id29876CSVPropertiesandValues.html

Specifically you are looking for the parameter: RSVP.CSV.DELIMITER

Rgds

Rob

My name is Grim and I approve this solution!  ;)