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