2 Replies Latest reply: Mar 3, 2014 8:42 AM by Fabrice Aunez RSS

    Import from CSV with quotes as a "date" field

      trying to import this CSV file,

       

      I can't get the extract_date field to read in Qlikview as a date.

       

      Probably a simple thing but I can't get it to work

       

      thanks!

       

      Dataset,GLN,GTIN,logische_controles_results,manual_audit_results,label_information_results,extract_date
      3M
        Nederland,"8713258999997","08710400791324","0",,,"25/02/14"

      PurgeChar(Dataset,Chr(34)) as Leverancier,
      PurgeChar(GLN,Chr(34)) as GLN_Leverancier,
      num(PurgeChar(GTIN,Chr(34))) as GTIN,
      PurgeChar(logische_controles_results,Chr(34)) as Logische_Controle_JN,
      if(
      PurgeChar(logische_controles_results,Chr(34))=0,
      'GOED',
      if(PurgeChar(logische_controles_results,Chr(34))=1,
      'FOUT',
      'NIET GECONTROLEERD'
      )
      )
      as Logische_Controle,
      PurgeChar(manual_audit_results,Chr(34)) as Handmatige_Controle_JN,
      if(
      PurgeChar(manual_audit_results,Chr(34))=0,
      'GOED',
      if(PurgeChar(manual_audit_results,Chr(34))=1,
      'FOUT',
      'NIET GECONTROLEERD'
      )
      )
      as Handmatige_Controle,
      PurgeChar(label_information_results,Chr(34)) as Etiket_Controle_JN,
      if(
      PurgeChar(label_information_results,Chr(34))=0,
      'GOED',
      if(PurgeChar(label_information_results,Chr(34))=1,
      'FOUT',
      'NIET GECONTROLEERD'
      )
      )
      as Etiket_Controle,
      PurgeChar(extract_date,Chr(34)) as Datum
      FROM
      [P:\******\*******\*.csv]
      (
      txt, codepage is 1252, embedded labels, delimiter is ',', no quotes);