Skip to content

    • Workbench

    Workbench

    How to set blank as encapsulating char in loading flat data files

    Member
    in Workbench

    Hi, I want to load data in flat files to DOMO using Workbench.

    My workbench is Workbench4.

     

    Each field is delimited by a Tab (so it is a TSV file) and there is no encapsulating char around a field.

    I want to load the files as they are, but Workbench does not allow me to set blank in "Encapsulate Fields With" text box in Source section.

     

    How can I do it?

     

     

    Welcome!

    It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
    Sign In

    Best Answer

    • Domo Employee
      Answer ✓

      I don't believe the csv parser in workbench allows for no encapsulating character. Usually if you put in double-quote or single-quote, or some more obscure character like tilde, that will allow your file to parse correctly.

    Answers

    • Contributor

      Hi all,

       

      Can anybody help @yoshidadaisu01 out?

      Thanks!

    • Domo Employee
      Answer ✓

      I don't believe the csv parser in workbench allows for no encapsulating character. Usually if you put in double-quote or single-quote, or some more obscure character like tilde, that will allow your file to parse correctly.

    • Domo Employee

      @BruceVolpe See response above, give me a like if this answers your question.

      Alex Peay
      Product Manager
      Domo
    This discussion has been closed.

    Welcome!

    It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
    Sign In

    Quick Links

    Categories