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.
