topic Re: Storing txt file to "UTF-8 without BOM" in QlikView

Storing txt file to "UTF-8 without BOM"

Thu, 20 Feb 2014 14:43:59 GMT

Hello community,

I store one field from a resident table loaded from a qvd to a txt file (I've also tried csv).

This txt file is saved with the UTF-8 BOM encoding.

The problem I have with this is that the file contains paths to images that I automatically convert with IrfanView (through the command line). But IfranView throws an error: "Can't read file header" because of the first BOM bytes.

Do you know of a way to automatically remove the BOM or can I change the store option? I've tried a bom remover tool but it had no "silent option" which is not an option.

Thank you,

Thorsten

Re: Storing txt file to "UTF-8 without BOM"

jerrysvensson — Thu, 20 Feb 2014 15:12:45 GMT

Could this help?

You can do this in a separate vbs script after your reload.

How store txt in ANSI ?

Re: Storing txt file to "UTF-8 without BOM"

Fri, 21 Feb 2014 07:41:09 GMT

Jerry,

do I put this script in a module or in the script and how would I call it then? Load, Execute, Call?

Re: Storing txt file to "UTF-8 without BOM"

jerrysvensson — Fri, 21 Feb 2014 07:47:35 GMT

Place the code in a vbsfile: For instance utftoansii.vbs

If you have Publisher I would set up an external program task that runs after your reload is finished.

Syntax : cscript.exe utftoansii.vbs

You could place it in QV also, open the macro dialog Ctrl-M and add the code.

Trigger the code in OnPostReload. You have start your reload with a batchjob though.

qv.exe /r app.qvw since Publisher doesn't run triggers.

Re: Storing txt file to "UTF-8 without BOM"

Fri, 21 Feb 2014 08:49:40 GMT

I need to process the txt file before the reload has finished. I'll try to find some tool that I can execute automatically.

Thanks.

Re: Storing txt file to "UTF-8 without BOM"

Fri, 21 Feb 2014 08:58:19 GMT

this little tool does it for me:

http://www.mannaz.at/codebase/utf-byte-order-mark-bom-remover/

Re: Storing txt file to "UTF-8 without BOM"

Tue, 02 Sep 2014 06:49:17 GMT

Hi Thorsten,

Stupid question: I need an automated process that calls bomremover.exe from the QlikView script, but it requires the user to click Enter before it runs.

Is this how you run it? I'm trying to find/remember how to send an <Enter> command, and coming up empty.

Re: Storing txt file to "UTF-8 without BOM"

Tue, 02 Sep 2014 07:58:34 GMT

Nevermind. Found it.

This works for me:

EXECUTE cmd.exe /c "echo. | c:\Temp\bomremover c:\Temp *.csv";