Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
vincentmecrin
New Contributor III

CodePage flat file

Hello,

I have a flat file containing datas from China, Korea, Taiwan, Hong Kong and Singapore. Name of poeple should be in his own language. For Chinese Korean and Taiwanese, i can not get a good result (for others countries, values are in latin).

When i load the file the codepage is set for all value but it's not the same for thoses languages. I tried to use applycodepage, but without succes.

Does anybody got an idea?

Thks

Vincent

4 Replies
Not applicable

Re: CodePage flat file

Vincent,

Can you "cut" the file or do several loads (with a WHERE statement) so that you can apply several code pages.

Fabrice

vincentmecrin
New Contributor III

Re: CodePage flat file

Fabrice,

First of all, thks for replying.

Several files or load is going to work for sure. I was trying to load file at once...

Vincent

agilos_mla
Contributor III

Re: CodePage flat file

Hi,

Force the unicode format in the load statement wiht the 'utf8' keyword.

Example:

(txt, utf8, embedded labels, delimiter is '\t', msq);

vincentmecrin
New Contributor III

Re: CodePage flat file

I have already tried utf8/7 or unicode and values are not properly reconized after load statement

Vincent

Community Browser