const escapeComma = (data) => {
try {
let result = data.toString().replaceAll(/,/g, "");
result = result.toString().replaceAll(/\\/g, "");
result = result.toString().replaceAll(/"/g, "''");
result = result.trim();
result = result.replace(/[\n\r]+/g, "");
return result;
} catch (error) {
log.error("Error @escapeComma", error)
return data;
}
}
titleArray = ["Item Code", "Brand", "Description", "Class", "Parent Class", "Sales Price", "Sales Invoice Cost", "Item Status", "Quantity Available", "GP $", "GP %", "Rebate Amount"];
csvFileData = titleArray.join(',')
for (i = 0; i < lines2.length; i++) {
desText = escapeComma(lines2[i].Description)
parentClassText = escapeComma(lines2[i].ParentClass)
clasText = escapeComma(lines2[i].Class)
csvFileData += '\n' + lines2[i].ItemCode + ',' + lines2[i].Brand + ',' + desText + ',' + clasText + ',' + parentClassText + ',' + lines2[i].SalesPrice + ',' + lines2[i].SalesInvoiceCost + ',' + lines2[i].ItemStatus + ',' + lines2[i].QtyAvailablePDC + ',' + lines2[i].GPamount + ',' + lines2[i].GPpercent + ',' + lines2[i].Rebateamount;
}
log.debug("csvfile", csvFileData)
// Create a CSV file
var csvFile = file.create({
name: 'ALL ITEM REBATE REPORT.csv',
fileType: file.Type.CSV,
contents: csvFileData,
encoding: file.Encoding.UTF8,
// folder:47940
});
log.debug("csv file", csvFile)