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
Post
by MattDavis » Thu Jan 14, 2010 11:55 am
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
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
Post
by Steve Rowe » Thu Jan 14, 2010 1:08 pm
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,
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
Post
by MattDavis » Thu Jan 14, 2010 1:39 pm
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
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
Post
by Steve Rowe » Thu Jan 14, 2010 2:32 pm
That movie didn't end well, the book was even worse!
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
Post
by kielmc » Thu Jan 14, 2010 7:20 pm
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!!
yyi
Community Contributor
Posts: 122 Joined: Thu Aug 28, 2008 4:42 am
Location: Sydney, Australia
Post
by yyi » Tue Oct 23, 2012 4:50 am
# take out double quotes
# use semi-colon instead of comma
DatasourceASCIIQuoteCharacter='';
DatasourceASCIIDelimiter=';';
Thanks for the posts everyone!
Yeon