11 Replies Latest reply: Nov 24, 2016 8:28 AM by Arnaldo Sandoval RSS

    Special characters on Excel

    Damian Aberbuj

      Hi,

       

      Im trying to load an excel file with special characters in fieldnames and possible values but QSense doesn't recognize it and gets trunk it

       

      For example:

       

      Selecting data generates the following code

      LOAD

          Service,

          "SA2505 Site Name",

          "SA2525 City",

          "SA2535 Region",

          "SA2540 Estado",

          o,                           -> It should be SA4508 Dueño

          SBE_EP,

          SBE_NTW,

          "SBE_Tipo de Servicio",

          "SBE_Sub Servicio",

          "O)"                       -> It should be SBE_Planeamiento Mensual Cliente (AÑO)

           .

      The same is happening in values.

       

      Any help on getting through this? I've created an ODBC connector for each file but is very annoying

       

      Many thanks.