TM1 Forum

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

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,

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

That movie didn't end well, the book was even worse!

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!!

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


Thanks for the posts everyone!