TM1 Forum

Hello All,

I am doing large data dumps > 25 million records using ASCIIOutput within TI Advance Data tab. The .txt file being generated as output has ' " ' on the dimension elements and values. I have to remove them before loading them into relational table.

Is there a way to avoid ' " ' being dumped within the Output file?

Thanks & Regards,

Ashwin

This family of functions work on both input and output, listed under TI local variables

DatasourceASCIIQuoteCharacter
This TurboIntegrator local variable sets the ASCII character used to enclose the fields of the source file when DatasourceType is 'CHARACTERDELIMITED'.

Syntax
DatasourceASCIIQuoteCharacter='Character';

Cheers,

Steve,

Got it. Thank you.

Regards,