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?
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"
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"
have you tried saving the file as a tab delimited file and then upload the tab delimited file to Domo?