Function to convert JSON to TSV file

/**
 * To convert JSON into TSV
 * @param{Object} objArray
 * @returns {string}
 */
function convertToTSV(objArray) {
    let jsonArray = typeof objArray != 'object' ? JSON.parse(objArray) : objArray;
    let str = 'FAILURE';
    if (jsonArray && util.isArray(jsonArray) && jsonArray.length) {
        str = '';
        let header = Object.keys(jsonArray[0]).join('\t');
        str = header + '\r\n';
        for (let lineIndex = 0; lineIndex < jsonArray.length; lineIndex++) {
            let line = '';
            for (let key in jsonArray[lineIndex]) {
                if (line != '') line += '\t';
                line += ((jsonArray[lineIndex][key] || "").toString()
                    .replace(/\t/g, "")
                    .replace(/\r\n/g, "")
                    .replace(/\r/g, "")
                    .replace(/\n/g, ""));
            }
            str += line + '\r\n';
        }
    }
    return str;
}

Leave a comment

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