Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear Team,
WE have one Chinese client recently and they would going to share some of the data(tab delimedted file ) in Chinese characters .
Can you please advise if qlikview is able to supports CHINESE CHARACTERS and if it required any changes during fetching of these files inside qlikview script.
Also where GUI would be able to show those CHINESE CHARACTERS .
Please guide.
Hi,
If you tab delimited file saved as in Unicode (UTF-8), you can Load the data normally.
Script
LOAD Month,
[Trader Code],
[Chinese Importer Name CN]
FROM
sample_chinese.txt
(txt, utf8, embedded labels, delimiter is '\t', msq);
sample attached..
Dear Settu,
Thanks for the above response.
Till date all the file format WERE NORMAL tab delimeted txt file .And in the qlikview script we are using as below:
Files:
LOAD *,
FROM $(File)
(txt, codepage is 1252, embedded labels, delimiter is '\t', msq);
This code is common across all the clients .Now how would I dynamically change the codepage to utf8 as you suggted above to handle Chinese characters specific for one clinet only?
How can I judge that file is in UTF8 or 1252 codepage?
pLEASE GUIDE.
UTF-8 files could be identified per BOM (Byte Order Mark) and here is a method to read this:
Re: Load CSV files with different format
- Marcus