5 Replies Latest reply: Oct 13, 2014 9:21 AM by Johannes Busenbach RSS

    Cryptic characters while reading from file

      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