Remove text delimiters from CSV export set

jimcalhoun
Kilo Expert

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?

11 REPLIES 11

Ashutosh Munot1
Kilo Patron
Kilo Patron

HI Jim,



Can i know from where are you exporting this.



Thank you,


Ashutosh


to a mid server


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


example:


var s = "'cat','mouse','make you lunch'";


gs.print(s.replace(/'/g, ''));



prints


cat,mouse,make you lunch