Discussion Board for collaboration on QlikView Scripting.
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?
It sounds like the file is UTF-16 encoded ...
You might be able to purgechar them.
View solution in original post
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.
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.
Check if this can help you
Thank you very much!
PurgeChar solved the problem.