Qlik Community

QlikView Documents

Documents for QlikView related information.

utf8_to_ansi

Employee
Employee

utf8_to_ansi

As we know QlikView stores text files only in UTF8 encoding.

For example

STORE MyTable to Export.csv(txt);

will save Export.csv as a UTF8 file.

If you need a file in ANSI encoding, QlikView does not provide an option to save it.

So I did this tiny program to convert the output of QlikView into ANSI

You can use it freely (no fees to me ) and distribute to your friends.

Example of use of it inside a QlikView Script:

STORE MyTable into Export.tmp(txt);

EXECUTE utf8_to_ansi.exe  Export.tmp Export.csv;

Labels (1)
Attachments
Comments
pavanthota
Contributor

Hi ,

Its Very helpful document, i tried but its not work for me. Can you please create one qlikview document and attach it hope it will help for all

Regards,

Pavan

0 Likes
Not applicable

Pavan, try changing the syntax so it says "INTO" instead of "TO":

STORE MyTable into Export.tmp(txt);

Partner
Partner

Great little tool, thanks for this time saver!

0 Likes
pljsoftware
Contributor III

Hi,

is possible to set the coding export in User Preference.

User Preference ANSI.png

Best Regards

Luca Jonathan Panetta

Version history
Revision #:
1 of 1
Last update:
‎2012-12-11 11:28 AM
Updated by: