topic Cryptic characters while reading from file in QlikView

Cryptic characters while reading from file

Mon, 13 Oct 2014 11:28:26 GMT

Hello,

I want to read data from a file. To do so I use the following line in my load script:

date#(@1, 'DD.MM.YYYY') AS dateField

The first field in file (it's a QlikView logfile) is a date.

After script execution the table has been filled with values but the dateField begins with two cryptic chars, looking like 'yb'.

Does anyone know about such a behaviour and how to fix it?

Thank you!

Johannes

jonathandienst — Mon, 13 Oct 2014 11:38:26 GMT

your statement looks OK, so I suggest that you post the first couple of lines of the log file, as well as the exact output you get.

Jonathan

Mon, 13 Oct 2014 11:53:05 GMT

These are the first lines of the log:

This is what I get in the preview of the first table the values are stored in:

The weird thing is, if I modify the log file and insert an empty row before the first row the preview is fine.

Johannes

flipside — Mon, 13 Oct 2014 12:12:16 GMT

It sounds like the file is UTF-16 encoded ...

https: //en.wikipedia.org/wiki/Byte_order_mark#UTF-16

You might be able to purgechar them.

flipside

ashfaq_haseeb — Mon, 13 Oct 2014 12:22:01 GMT

Hi,

Check if this can help you

Regards

ASHFAQ

Mon, 13 Oct 2014 13:21:43 GMT

Thank you very much!

PurgeChar solved the problem.

Johannes