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
ASCII Output
- 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
Hi Radhika,Radhika wrote:Can you please tell me which function should I use to eliminate the "" from the all the above strings.
You can use DatasourceASCIIQuoteCharacter = ''; for this.
Michel
-
- 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
Thank you for your quick response Michel.