This topic is locked
Export Help 12/5/2020
ASPRunner.NET General questions
Lowkeck

Good Afternoon,
Can anyone offer some advice on how best to remove quotation marks when exporting data to CSV format? Here is a sample of my output file.
"EmpID","DET","DETCODE","Hrs","Amount","TempRate","RateCode","CostCenter1","CostCenter2","CostCenter3","LeaveBlank1","LeaveBlank2","Jobcode","ShiftC","PunchIN","PunchOut","WorkersCompCode","TCode1","TCode2","TCode3","TCode4","Sequence#","CheckType","CheckNumber"

"178","E","OT","8","","35","","210001","100","500-00","","","14-94501","","2020-12-05 00:00:00","2020-12-05 00:00:00","","","","","","","",""

"178","E","OT","5","","1","","210001","100","500-00","","","14-94501","","2020-12-07 00:00:00","2020-12-07 00:00:00","","","","","","","",""

"178","E","OT","8","","1","","210001","100","500-00","","","000","","2020-12-06 00:00:00","2020-12-06 00:00:00","","","","","","","",""
Obviously, I know I can open the file and do a quick find and replace but I am trying to do this programmatically so my end users don't need to.
Any help would be greatly appreciated.

admin 12/7/2020

You will have to create your own export routine if you need to make a change like this. You can add the custom button to the page, create CSV file in the Server part of the button and send it to the output.