ASCII Output formatting question

Post Reply
MattDavis
Posts: 7
Joined: Wed Dec 02, 2009 11:50 am
OLAP Product: TM1
Version: 9.0 9.4 and 9.5
Excel Version: 2003 and 2007

ASCII Output formatting question

Post by MattDavis »

hello all

I am trying to produce a text file in a TI process but I need to format the output _without_ text qualifying quotes, in a csv.

I have rtfm :) but can't see how I can do this in the TI itself...

Is it possible or must I do something funky in VBA instead?

Matt
It always used to be about the brackets, now it's about the semicolon
User avatar
Steve Rowe
Site Admin
Posts: 2456
Joined: Wed May 14, 2008 4:25 pm
OLAP Product: TM1
Version: TM1 v6,v7,v8,v9,v10,v11+PAW
Excel Version: Nearly all of them

Re: ASCII Output formatting question

Post by Steve Rowe »

Hi Matt,

Sometimes RTFM doesn't help since some of the information is missing!

If you look at TI Local Variables section you will see a bunch of variables that start DataSourceASCII.....
I'm 99% sure that these can be used to manage the format of ASCIIoutput too.

Cheers,
Technical Director
www.infocat.co.uk
MattDavis
Posts: 7
Joined: Wed Dec 02, 2009 11:50 am
OLAP Product: TM1
Version: 9.0 9.4 and 9.5
Excel Version: 2003 and 2007

Re: ASCII Output formatting question

Post by MattDavis »

Steve, you are a legend

I'd like to give you 1% to make you 100% certain. you are correct!

Thanks very much indeed

Matt
It always used to be about the brackets, now it's about the semicolon
User avatar
Steve Rowe
Site Admin
Posts: 2456
Joined: Wed May 14, 2008 4:25 pm
OLAP Product: TM1
Version: TM1 v6,v7,v8,v9,v10,v11+PAW
Excel Version: Nearly all of them

Re: ASCII Output formatting question

Post by Steve Rowe »

That movie didn't end well, the book was even worse! :lol:
Technical Director
www.infocat.co.uk
User avatar
kielmc
Posts: 22
Joined: Tue Jun 24, 2008 6:17 pm
OLAP Product: TM1
Version: 10.2.2 FP4
Excel Version: 2013
Location: Birmingham, AL

Re: ASCII Output formatting question

Post by kielmc »

Where has this been all of my life? I'm getting nauseous thinking about how many times I've had to jump through hoops to get rid of those quotes!!
User avatar
yyi
Community Contributor
Posts: 122
Joined: Thu Aug 28, 2008 4:42 am
Location: Sydney, Australia

Re: ASCII Output formatting question

Post by yyi »

# take out double quotes
# use semi-colon instead of comma
DatasourceASCIIQuoteCharacter='';
DatasourceASCIIDelimiter=';';


Thanks for the posts everyone!
Yeon
Post Reply