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

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? 

 

Best Answer

  • GrantSmith
    GrantSmith 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

  • Neeti
    Neeti 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

     

  • GrantSmith
    GrantSmith 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!**
  • Godzilla
    Godzilla 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'