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

user017486

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? 

 

GrantSmith

@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"

 

Neeti

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

@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"

 

Godzilla

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