TM1 Forum

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

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

Thank you for your quick response Michel.