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

Reply
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? 

 


Accepted Solutions
Black Belt

@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!**

View solution in original post

Tags (1)

All Replies
Green Belt

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)
Black Belt

@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!**

View solution in original post

Tags (1)
Major Brown Belt

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
New & Improved Dojo: Get excited for a new feel and additional features in the online community.

Site will be down February 4-5th for maintenance.

Launch coming February 8th!