Importing a CSV using SFTP and double quotation marks to isolate the data

Hi, this is a bit of an odd question but will do my best to ask it.
I have a CSV file i am pulling for a SFTP, the file is in a CSV format and pulls the headers and first cell but it stops.
After each comma the data is wrapped in double quotation marks, for example:
12328354,"User Name","1","Company Brand, Town"
from that example the last element of data has a comma within the quotation marks but is one cell of data.
Is there a connector i can use to get this importing?
Thanks
Rob
Best Answer
-
HI @trafalger, I have worked out that I can use the CSV advanced connector, I can use a http csv or sftp connector within that, in the configuration I can then set it to allow the double quotations and commas within the quotations will not be processed.
Thanks
Rob
0
Answers
-
How are you pulling it now? Manually? Could you use the SFTP connector?
1 -
HI @trafalger, I have worked out that I can use the CSV advanced connector, I can use a http csv or sftp connector within that, in the configuration I can then set it to allow the double quotations and commas within the quotations will not be processed.
Thanks
Rob
0
Categories
- All Categories
- 1.2K Product Ideas
- 1.2K Ideas Exchange
- 1.3K Connect
- 1.1K Connectors
- 273 Workbench
- 1 Cloud Amplifier
- 3 Federated
- 2.7K Transform
- 78 SQL DataFlows
- 525 Datasets
- 2.1K Magic ETL
- 2.9K Visualize
- 2.2K Charting
- 434 Beast Mode
- 22 Variables
- 510 Automate
- 114 Apps
- 388 APIs & Domo Developer
- 8 Workflows
- 26 Predict
- 10 Jupyter Workspaces
- 16 R & Python Tiles
- 332 Distribute
- 77 Domo Everywhere
- 255 Scheduled Reports
- 66 Manage
- 66 Governance & Security
- 1 Product Release Questions
- Community Forums
- 40 Getting Started
- 26 Community Member Introductions
- 68 Community Announcements
- 4.8K Archive