ASCII Output

Post Reply
Radhika
Posts: 97
Joined: Mon Sep 27, 2010 6:49 am
OLAP Product: IBM Cognos TM1
Version: v9.4.1
Excel Version: Microsoft Excel 2003

ASCII Output

Post by Radhika »

Hi All,

I am trying to export the data from a view through TI using an ASCII function.

Data Tab
---------
DatasourceASCIIDelimiter=';';
TextOutput('xyz.txt',v1,v2,v3,v4,v5,v6,value);

when I use the above script the data is exported in the below format

"GO Americas";"Golf Shop";"Golf Accessories";"Jan";"Budget Version 1";"Quantity";"853."

Can you please tell me which function should I use to eliminate the "" from the all the above strings. The output should look like

GO Americas;Golf Shop;Golf Accessories;Jan;Budget Version 1;Quantity;853.

Thanks,
Radhika
User avatar
Michel Zijlema
Site Admin
Posts: 713
Joined: Wed May 14, 2008 5:22 am
OLAP Product: TM1, PALO
Version: both 2.5 and higher
Excel Version: 2003-2007-2010
Location: Netherlands
Contact:

Re: ASCII Output

Post by Michel Zijlema »

Radhika wrote:Can you please tell me which function should I use to eliminate the "" from the all the above strings.
Hi Radhika,

You can use DatasourceASCIIQuoteCharacter = ''; for this.

Michel
Radhika
Posts: 97
Joined: Mon Sep 27, 2010 6:49 am
OLAP Product: IBM Cognos TM1
Version: v9.4.1
Excel Version: Microsoft Excel 2003

Re: ASCII Output

Post by Radhika »

Thank you for your quick response Michel.
Post Reply