Export CSV replace header names on columns

bfarkas

Has anyone ever replaced the header names on the columns for export only for CSV?
I was thinking of trying the data interception approach, but not sure if I am overthinking this.
For excel I can say don't include the header and then insert a line, but the insert does not seem to be available for csv.

kthorngren

See if this thread helps.

Kevin

bfarkas

Thanks Kevin, that got me on the right track.
I have hidden the real header and then can do the customize.
One thing still trying to sort, the goal is to simulate a header, so I have the commas added, but if I do quotes it fails because of escaping and the function. Is there a way around that?

So for instance, this is the customize function

customize: function (csv) {
                return "1,2,3,5,7,8,9,10,11,12,13,14,15,16,17,18\n"+  csv;
                },

If I update it to the below which is my goal, it fails:

customize: function (csv) {
                return ""1","2","3","5","7","8","9","10","11","12","13","14","15","16","17","18"\n"+  csv;
                },

kthorngren

If you want each header wrapped in " then use single quotes for the string, for example:
return '"1","2","3","5","7","8","9","10","11","12","13","14","15","16","17","18"\n'+ csv;

Kevin

bfarkas

So simple. Thanks Kevin!