topic Re: Store to txt file encoding ansi in QlikView

Store to txt file encoding ansi

gidon500 — Tue, 20 Feb 2018 14:03:01 GMT

Hello

I am using this script

aa:
LOAD * INLINE [
F1
1
2
3
4
];

STORE * from aa into aaa.txt (txt) ;

setting is:

default export encoding is ansi in document properties

default user setting is Encoding ansi

the problem is that the aaa.txt file encoding is UTF-8

I need it ansi .

what am I doing wrong ?

thanks

gidon

Re: Store to txt file encoding ansi

Miguel_Angel_Baeyens — Tue, 20 Feb 2018 14:20:26 GMT

The STORE command in QlikView always produces UTF8 encoded files. If you need a different encoding you will need to do it via macro (credit to chriscammers) or out of QlikView, with a command line program you can call from the script using EXECUTE, for example.

Re: Store to txt file encoding ansi

YoussefBelloum — Tue, 20 Feb 2018 14:26:46 GMT

Hi,

Store command use only UTF format.

for other formats you must use Macros

Re: Store to txt file encoding ansi

gidon500 — Tue, 20 Feb 2018 18:44:12 GMT

thanks

Re: Store to txt file encoding ansi

gidon500 — Tue, 20 Feb 2018 18:44:25 GMT

thanks

Re: Store to txt file encoding ansi

gidon500 — Tue, 20 Feb 2018 20:43:06 GMT

I am using this macro

Sub ExportToTextfile

Set tableObject = ActiveDocument.GetSheetObject("TB19")

tableObject.Export "C:\Users\Gidon\Desktop\New folder\TEST.txt",Chr(9)

End Sub

it works great but how can I store without the lables .

thanks

gidon

Re: Store to txt file encoding ansi

gidon500 — Tue, 20 Feb 2018 20:43:30 GMT

I am using this macro

Sub ExportToTextfile

Set tableObject = ActiveDocument.GetSheetObject("TB19")

tableObject.Export "C:\Users\Gidon\Desktop\New folder\TEST.txt",Chr(9)

End Sub

it works great but how can I store without the lables .

thanks

gidon

Re: Store to txt file encoding ansi

Miguel_Angel_Baeyens — Wed, 21 Feb 2018 07:20:24 GMT

With that script, you cannot, because you are calling an object (TB19) which does not exist at the time of loading the script.

Instead you will need to create a table in the script itself which contains all the data you want to save with that encoding. Then you use the Call function:

TableToAnsi:

LOAD *

RESIDENT Othertable;

Call ExportToTextfile(); // the macro stores the results of the table "TableToAnsi" into the TXT file.

// more script here

What I have seen more often is to first STORE the file as TXT which is UTF8 and then use the macro call to convert that TXT file from UTF8 to Windows1252 or the ANSI you need to use.

Re: Store to txt file encoding ansi

gidon500 — Wed, 21 Feb 2018 13:22:28 GMT

I get syntax error when I run this script

what am I doing from

gidon

Re: Store to txt file encoding ansi

Miguel_Angel_Baeyens — Wed, 21 Feb 2018 15:30:46 GMT

Which script?

Re: Store to txt file encoding ansi

gidon500 — Wed, 21 Feb 2018 16:09:10 GMT

TableToAnsi:
LOAD * INLINE [
    F1
    1
    2
    3
    4
];

Call ExportToTextfile () ;

exit SCRIPT ;

// the macro stores the results of the table "TableToAnsi" into the TXT file.

// this is the macro

Sub ExportToTextfile

Set tableObject = ActiveDocument.GetSheetObject("TB01")

tableObject.Export "C:/TEST.txt",Chr(9)

End Sub

Re: Store to txt file encoding ansi

Miguel_Angel_Baeyens — Wed, 21 Feb 2018 17:47:41 GMT

So basically:

the Sub ... End Sub script must be in the script before the Call function, else the function is not defined and therefore the error.
As mentioned before, during the load script you cannot use .GetSheetObject() as the object does not exist yet, this may not cause any error but will result in an empty file. Instead, you have to create a table in the script and export such table.

The sequence is

Define function
Load data
Call function

I think the example by Chris is quite good, but there are sure others in the Qlik Community.