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-08-2017 07:10 AM
HI Jim,
Can i know from where are you exporting this.
Thank you,
Ashutosh
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎12-08-2017 10:44 AM
to a mid server
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎12-08-2017 12:25 PM
if you can read each line of the export as a string, you can get rid of the first line, then for the others you can do
line.replace(/<single quote' or double quote">/g, "") // replace all occurrences of a single or double quote with empty string
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎12-08-2017 12:28 PM
example:
var s = "'cat','mouse','make you lunch'";
gs.print(s.replace(/'/g, ''));
prints
cat,mouse,make you lunch