HELP: ASCIIOUTPUT issues

User avatar
PavoGa
MVP
Posts: 617
Joined: Thu Apr 18, 2013 6:59 pm
OLAP Product: TM1
Version: 10.2.2 FP7, PA2.0.9.1
Excel Version: 2013 PAW
Location: Charleston, Tennessee

Re: HELP: ASCIIOUTPUT issues

Post by PavoGa »

Extending on what Wim has pointed out, simplifying output (and assuming no numeric data that requires formatting:

Code: Select all

DatasourceASCIIQuoteCharacter='';
vTab=Char(9);
vDoubleQuote=Char(39);
asciioutput ( 'c:\file.txt' , EXPAND(%field1%%vTab%%field2%"%vDoubleQuote%s%vTab%%field3%' ));
Or even:

Code: Select all

DatasourceASCIIQuoteCharacter='';
#  Better yet, TAB is implicitly embedded in the output string
vDoubleQuote=Char(39);
asciioutput ( 'c:\file.txt' , EXPAND('%field1%	%field2%"s	%field3%') );
If you do not require formatted numeric data in the output:

Code: Select all

DatasourceASCIIQuoteCharacter='';
# vNumberVar = a constant, calculation result, datasource variable or some combination 
#	without having to do a NumberToString conversion.
# TAB is implicitly embedded in the output string
vDoubleQuote=Char(39);

asciioutput ( 'c:\file.txt' , EXPAND('%field1%	%field2%"s	%field3%	%vNumberVar%') );
Ty
Cleveland, TN
Post Reply