Data Output using Asciioutput
-
- Posts: 90
- Joined: Tue Aug 19, 2008 4:56 pm
Data Output using Asciioutput
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?
- 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
Set the DatasourceASCIIQuoteCharacter variable to an empty string: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?
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.
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.