How to create a csv file from a search result

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)

Leave a comment

Your email address will not be published. Required fields are marked *