9 Replies Latest reply: Aug 25, 2016 9:16 AM by Paul Pichler RSS

    Import File containing field (US) and Row (RS) separator

    Paul Pichler

      Hi,

       

      my txt file contains both field (US) and row (RS) separators:

      Example.PNG

      I can only define one separator within the wizard for importing tables:

      Example_3.PNG

      If I choose US (\x1f), the load script generates an error (field not found) for the last column (Column 3), because it cannot resolve the "RS" separator.

       

      Example_2.PNG

       

      Example_4.PNG

       

      How can I import this file to QV? Is it possible to define both field and row separators within the table import wizard?


      Many thanks,

      Paul