topic Re: Store during script run a table to txt file using ansi encoding in QlikView

Store during script run a table to txt file using ansi encoding

gidon500 — Fri, 23 Feb 2018 11:06:14 GMT

for my customer I need to create txt file with ansi encoding during script run . ,

( it is possible to store to UTF-8 using STORE command )

the reason why I need during script run is that I manipulate the data to several tables and need different data to store .

the use on txt file , is to move data from one system to another .

enclosed a qvw sample document .

I some can add the right script line to make it happen .

I know it is possible but I could not make it happen

thanks for the help

gidon

Re: Store during script run a table to txt file using ansi encoding

marcus_sommer — Fri, 23 Feb 2018 12:08:37 GMT

It's not possible directly with Qlik. You will need some third-party tools maybe a sophisticated editor or any batch-routine. I think this will be helpful in this way:

Re: Re: How store txt in ANSI ?

utf8_to_ansi

- Marcus

Re: Store during script run a table to txt file using ansi encoding

Peter_Cammaert — Fri, 23 Feb 2018 12:31:31 GMT

Or with some command line magic: https://www.dostips.com/forum/viewtopic.php?t=3922#p21364

Note that in text strings you may lose some information. Converting Unicode to an ANSI codepage isn't always lossless