TM1 Forum

Hello,
I'm using ASCIIOutput to create a file but need it to be a tab delimited type.
Does anyone know if it's possible to specifiy this in TI?
Thanks for your help,
Fionnuala

It is comma delimited only as far as I am aware. You could write a btach file that opens the file and replaces commas with tabs. You could run the batch within TI after the ASCIIOuput has finished,

Jim.

Thanks Jim, I'll try that.
It certainly seems like there's no option in TI so a batch file might do the trick.
Thanks,
Fionnuala
BTW I'm using 9.4FP3

Hi,

You can use the DatasourceASCIIDelimiter TI variable to specify the field separator.
F.i.: DatasourceASCIIDelimiter=Char(code);
where code is the ascii code for tab.

Michel

Thanks very much Michel, that seems to have worked with the code 9 for tab..
I just need to get rid of the "" around each field now,
Regards,
Fionnuala

ok I have it with
DatasourceASCIIDelimiter=Char(9);
DatasourceASCIIQuoteCharacter='';

Thanks for your help,
Fionnuala

Fionnuala wrote:Thanks very much Michel, that seems to have worked with the code 9 for tab..
I just need to get rid of the "" around each field now

You can use the DatasourceASCIIQuoteCharacter variable for that:
DatasourceASCIIQuoteCharacter='';

Michel

Edit - Ok, you already found that