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 Indiana 🔴
    Accepted 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"

     

Answers

  • 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

     

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