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

Reply
Highlighted
White Belt

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? 

 

Highlighted
Green Belt

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

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

 

Tags (2)
Highlighted
Blue Belt

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

@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 the heart icon**

**Did this solve your problem? Accept it as a solution!**
Tags (1)
Major Brown Belt

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

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'
Announcements
Want to join our weekly online meet up? Please visit this board here and let me know. Click here for more details!