ASCIIOutput to not have ' " ' on Elements

[ashwinchitkara]

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

[Steve Rowe]

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,

[ashwinchitkara]

Steve,

Got it. Thank you.

Regards,