Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
I have a CSV file , which have chinese charater. When i using my note book to open the CSV file , the chinese charater become funny charater look like below :-
When i import the raw data , using the below auto generate script :-
Directory;
LOAD [Customer/Vendor],
[Customer Name]
FROM
SI_MC.csv
(txt, utf8, embedded labels, delimiter is ',', msq);
I google the past post , it said that i need to import as utf8 , below is the image i get from Qlik View for company field.
Hope some one can share with me how to solve this ?
My note book is win 10 , i already install with chinese font , but when using excel open the CSV file , i still see funny charater. ( when i try to get the IT staff generate give me XLSX ( Microsoft Excel Worksheet ) , i can see the chinese charater , but for this project i must use CSV file.
Enclosed my raw data file onlt 3 row.
The file is not UTF 8, it has a Chinese code page. You need to find out which code page was used when the file was created.
For example:
// Chinese Simlified (GB2312)
CP936:
LOAD
[Customer/Vendor],
[Customer Name]
FROM SI_MC.csv (txt, codepage is 936, embedded labels, delimiter is ',', msq);
// Chinese Tratitional (Big5)
CP950:
LOAD
[Customer/Vendor],
[Customer Name]
FROM SI_MC.csv (txt, codepage is 950, embedded labels, delimiter is ',', msq);
The file is not UTF 8, it has a Chinese code page. You need to find out which code page was used when the file was created.
For example:
// Chinese Simlified (GB2312)
CP936:
LOAD
[Customer/Vendor],
[Customer Name]
FROM SI_MC.csv (txt, codepage is 936, embedded labels, delimiter is ',', msq);
// Chinese Tratitional (Big5)
CP950:
LOAD
[Customer/Vendor],
[Customer Name]
FROM SI_MC.csv (txt, codepage is 950, embedded labels, delimiter is ',', msq);
Ok, your file use Chinese Simplified as codepage. Loading with (txt, codepage is 936, embedded labels, delimiter is ',', msq) give the correct result.
Hi Sir
Thank you very much.
Paul Yeo