topic Re: ANSI coding in textfile from macro in QlikView

ANSI coding in textfile from macro

Anonymous — Fri, 09 Jan 2015 12:31:39 GMT

Hi everyone,

I have this macro (VBScript) in which I export a table into a textfile:

Sub ExportToTextfile

Set tableObject = ActiveDocument.GetSheetObject("TB01")

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

End Sub

My problem is that the exported file has an UTF-8 encoding. I would like to export into ANSI encoding, or convert it into ANSI encoding if possible. Anybody here that knows this?

Best regards,

Filip

Re: ANSI coding in textfile from macro

marcus_sommer — Fri, 09 Jan 2015 14:02:21 GMT

There are two further parameter after the delimiter-parameter possible - the codepage and appending to an existing file with true/false.

Codepage number, e.g. :
0          =   current ANSI
1200     =   Unicode
65001   =   UTF-8

- Marcus

Re: ANSI coding in textfile from macro

Anonymous — Fri, 09 Jan 2015 14:33:33 GMT

I don't get it... In what context should I use the 0 codepage?

Re: ANSI coding in textfile from macro

marcus_sommer — Fri, 09 Jan 2015 14:37:32 GMT

...

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

...

- Marcus

Re: ANSI coding in textfile from macro

Anonymous — Fri, 09 Jan 2015 14:41:33 GMT

Thanks... But unfortunately i still get UTF-8 encoding...

Re: ANSI coding in textfile from macro

marcus_sommer — Fri, 09 Jan 2015 14:50:11 GMT

In regard to the APIGuide.qvw it should work. You could also try it with "ExportEx" - see the picture.

- Marcus

Re: ANSI coding in textfile from macro

jerrysvensson — Fri, 09 Jan 2015 14:52:51 GMT

This works, just tried it.

Sub ExportToTextfile
Set tableObject = ActiveDocument.GetSheetObject("TB28")
tableObject.Export "C:\TEST.txt",",",0
End Sub

Re: ANSI coding in textfile from macro

Anonymous — Fri, 09 Jan 2015 14:59:24 GMT

Doesn't work for me actually, seems strange...

Re: ANSI coding in textfile from macro

marcus_sommer — Fri, 09 Jan 2015 15:05:06 GMT

Maybe it's also connected with the user-properties about the charset within the tab export ...

- Marcus

Re: ANSI coding in textfile from macro

Anonymous — Fri, 09 Jan 2015 15:13:09 GMT

Yes, you are correct Marcus!

Thanks a lot!!

But does this setting affect regular export from charts to excel (such as pivot tables) or only text file exports?

Best,

Filip

Re: ANSI coding in textfile from macro

marcus_sommer — Fri, 09 Jan 2015 15:19:04 GMT

I think it should be a global setting but don't touch the excel-export - but I'm not really sure.

- Marcus

Re: ANSI coding in textfile from macro

Anonymous — Fri, 09 Jan 2015 15:34:18 GMT

OK - thanks for your help!

Have a nice weekend!