asciioutput formatted as scientif...

Post Reply
kbogies
Posts: 31
Joined: Tue Jun 10, 2008 8:21 pm
OLAP Product: TM1
Version: 9.1sp4 64x
Excel Version: 2003
Location: Hartford, CT

asciioutput formatted as scientif...

Post by kbogies »

Hi All,
I'm on 9.0 sp3 and have an Asciiout put TI process where some of the data ia exporting as scientific formatting. Our SQL consultant cannot automate the data with these sceintific formats, and there seems to no consistancy to the general vs. scientific format on the .csv extract.

Does anyone know how to ensure the format of the extract will be general?

ASCIIOutput('\\tltm1pm1\tm1_ODBC_Data\FMR\FinPlan.csv', Vyear, actvsbud, channels, PRODUCT, INSTYPE, INCSTAT, MONTH1, Data);
kbogies
Posts: 31
Joined: Tue Jun 10, 2008 8:21 pm
OLAP Product: TM1
Version: 9.1sp4 64x
Excel Version: 2003
Location: Hartford, CT

Re: asciioutput formatted as scientif...

Post by kbogies »

I'm all set after adding a numbertostring function in the formula:-)
Post Reply