TM1 Forum

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.

Use TextOutput rather than AsciiOutput.

Is it the only difference between those two functions?

Catherine wrote:Is it the only difference between those two functions?

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.

Thank you !