Outputting fixed width text files

Post Reply
fleaster
Regular Participant
Posts: 167
Joined: Wed Mar 30, 2011 11:57 pm
OLAP Product: TM1
Version: 10.2.2
Excel Version: XL2010

Outputting fixed width text files

Post by fleaster »

Ok here's a dumb question - anyone have any tips on outputting fixed width text files using TI?

Now I know you can use ASCIIOUTPUT and make 1 big concatenated field, however how do you stop TI from adding the " " quotes around each line?

...if anyone has any quick tips it would be appreciated :)

thanks!

Matt
Duncan P
MVP
Posts: 600
Joined: Wed Aug 17, 2011 1:19 pm
OLAP Product: TM1
Version: 9.5.2 10.1 10.2
Excel Version: 2003 2007
Location: York, UK

Re: Outputting fixed width text files

Post by Duncan P »

Search DatasourceASCIIQuoteCharacter.
fleaster
Regular Participant
Posts: 167
Joined: Wed Mar 30, 2011 11:57 pm
OLAP Product: TM1
Version: 10.2.2
Excel Version: XL2010

Re: Outputting fixed width text files

Post by fleaster »

Thanks Duncan... am assuming this refers to the data source - will it also apply for OUTPUT format as well though...?
Duncan P
MVP
Posts: 600
Joined: Wed Aug 17, 2011 1:19 pm
OLAP Product: TM1
Version: 9.5.2 10.1 10.2
Excel Version: 2003 2007
Location: York, UK

Re: Outputting fixed width text files

Post by Duncan P »

It does. DatasourceASCIIDelimiter also applies to both.
Post Reply