SetInputCharacterSet is not working

Post Reply
User avatar
roei61
Posts: 27
Joined: Wed Aug 22, 2012 5:44 am
OLAP Product: TM1
Version: 10.2.2
Excel Version: 2016
Location: Israel

SetInputCharacterSet is not working

Post by roei61 » Sun Dec 11, 2016 7:06 am

Hi Experts,

I have a TXT file that being overwritten every night and then being loaded to the TM1.
For some reason in some of the nights the file is being loaded with strange characters.
After checking this issue, we found that the file UNICODE on the problematic loadings is OEM United States instead of UTF-8.

I added the code below to the prolog, but it still not being loaded as UTF-8.
This code seems to work only in CSV.
Do you know how it can be done with TXT without changing the original file format?

Code: Select all

SetInputCharacterSet ('TM1CS_UTF8');
Any ideas?

Thanks

Post Reply