Skip to content

    • Connectors

    Connectors

    I want to upload a CSV String to domo in which a column contains a ","

    Member
    in Connectors

    Hi,

    I want to upload a CSV String to domo in which a column contains a ","... eg i have a string "abc,xyz" and i want to upload this CSV into a single column. but when i try to upload DOMO considers the "," in the string and try to upload into 2 coulmns.

     

    How do i upload CSV string containing "," ie "abc,xyz" into a single column? 

     

    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

    • Coach
      Answer ✓

      @user017486 

       

      How are you uploading the data to Domo? What connector are you using?  You should be able to encapsulate the value containing a comma with double quotes to treat it as a single value:

       

      Column 1, Column 2, Column 3

      one, two, "three, four"

       

      **Was this post helpful? Click Agree or Like below**
      **Did this solve your problem? Accept it as a solution!**

    Answers

    • Member

      Hi @user017486 ,

       

      I suggest you to connect your file using file connector and you can user Magic ETL for this, use Repalce text or even combile columns, split columns, etc to do this.

       

      **Say "Thanks" by clicking the "heart" in the post that helped you.
      **Please mark the post that solves your problem by clicking on "Accept as Solution"

       

      Thanks,

      Neeti

       

    • Coach
      Answer ✓

      @user017486 

       

      How are you uploading the data to Domo? What connector are you using?  You should be able to encapsulate the value containing a comma with double quotes to treat it as a single value:

       

      Column 1, Column 2, Column 3

      one, two, "three, four"

       

      **Was this post helpful? Click Agree or Like below**
      **Did this solve your problem? Accept it as a solution!**
    • Contributor

      have you tried saving the file as a tab delimited file and then upload the tab delimited file to Domo?

      Domo Arigato!

      **Say 'Thanks' by clicking the thumbs up in the post that helped you.
      **Please mark the post that solves your problem as 'Accepted Solution'

    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

    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