Hi,
I have to extract data into a flat file which I do, using the asciioutput in TI. The data is supposed to be imported into a SQL database, which shows a error because of the "0x1A" at the end of the file.
Is there any possibility to erase this character (other than by hand, because the data is extracted every night).
Thank you.
"0x1A" in asciioutput
-
Catherine
- Posts: 110
- Joined: Wed May 20, 2009 7:30 am
- OLAP Product: TM1
- Version: 10.2.2 - PA
- Excel Version: 2010
- Location: Rennes, France
Re: "0x1A" in asciioutput
Is it the only difference between those two functions?
-
Alan Kirk
- Site Admin
- Posts: 6667
- 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: "0x1A" in asciioutput
No; ASCIIOutput was the original method from the days when TM1 could only handle... well, ASCII. TextOutput was introduced in conjunction with the change to Unicode. It can write in the machine's local character set which you can also vary via the SetOutputCharacterSet function.Catherine wrote:Is it the only difference between those two functions?
"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.
-
Catherine
- Posts: 110
- Joined: Wed May 20, 2009 7:30 am
- OLAP Product: TM1
- Version: 10.2.2 - PA
- Excel Version: 2010
- Location: Rennes, France
Re: "0x1A" in asciioutput
Thank you !