Data Output using Asciioutput

Post Reply
cdhodge2002
Posts: 90
Joined: Tue Aug 19, 2008 4:56 pm

Data Output using Asciioutput

Post by cdhodge2002 »

I am using an Asciioutput function in order to export data from TM1, however my client has requested that I take off the quotes variable outputs. Does anybody know how to do this in TM1 or does this need to be done outside of TM1 and how is the best was to do this outside of TM1?
User avatar
Alan Kirk
Site Admin
Posts: 6608
Joined: Sun May 11, 2008 2:30 am
OLAP Product: TM1
Version: PA2.0.9.18 Classic NO PAW!
Excel Version: 2013 and Office 365
Location: Sydney, Australia
Contact:

Re: Data Output using Asciioutput

Post by Alan Kirk »

cdhodge2002 wrote:I am using an Asciioutput function in order to export data from TM1, however my client has requested that I take off the quotes variable outputs. Does anybody know how to do this in TM1 or does this need to be done outside of TM1 and how is the best was to do this outside of TM1?
Set the DatasourceASCIIQuoteCharacter variable to an empty string:

Code: Select all

AsciiOutput ('C:\Temp\Example.txt', 'This will have quotes');

DatasourceASCIIQuoteCharacter='';

AsciiOutput ('C:\Temp\Example.txt', 'And this will not');
"To them, equipment failure is terrifying. To me, it’s 'Tuesday.' "
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
Post Reply