Remove text delimiters from CSV export set
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎12-08-2017 07:02 AM
I have an export set that is scheduled daily, a requirement of the export is not to have the column headers and no text delimiters (currently exporting with " " around the text) only the comma between field values.
Is it possible to remove the headers and quotes from the export?
- Labels:
-
Scripting and Coding
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎12-14-2017 09:54 AM
Are your sure none of your fields contain commas? The point of the quotes was to prevent premature separation through comma misinterpretation.
An alternative approach is: use the REST API to obtain the data on your target system, rather than export it from the source. It could be pulled as XML or JSON, available to be manipulated target-side as you see fit.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎12-14-2017 10:01 AM
Yes my data has no commas.