topic Re: Available STORE formats in QlikView

Available STORE formats

hopkinsc — Tue, 20 Mar 2018 11:35:02 GMT

Hi all,

I have a query on what formats are possible in the store command.

I currently store a table out as a text file in the following format:

(txt, utf8, no labels, delimiter is '|', no quotes);

UTF8 includes multi-byte character sets, what i need is a format that doesn't include multi-byte (only single byte).

does anyone know if QlikView can export in any single byte formats?

Thanks in advance

Re: Available STORE formats

Peter_Cammaert — Tue, 20 Mar 2018 12:13:54 GMT

According to the Help (see Store - QlikView‌) STORE doesn't offer a text export other than in UTF-8. You can always convert the generated file to ANSI/ASCII afterwards. See for example Store during script run a table to txt file using ansi encoding

Note that two of your options - no labels, no quotes - won't do anything when executing the STORE statement. Luckily, they won't crash script execution either ...

Re: Available STORE formats

hopkinsc — Tue, 20 Mar 2018 13:18:03 GMT

Thanks Peter, i'll take a look.