70 lines
2.4 KiB
JavaScript
70 lines
2.4 KiB
JavaScript
"use strict";
|
|
Object.defineProperty(exports, "__esModule", { value: true });
|
|
exports.csvToMarkdown = void 0;
|
|
/**
|
|
* Converts CSV to Markdown Table
|
|
*
|
|
* @param {string} csvContent - The string content of the CSV
|
|
* @param {string} delimiter - The character(s) to use as the CSV column delimiter
|
|
* @param {boolean} hasHeader - Whether to use the first row of Data as headers
|
|
* @returns {string}
|
|
*/
|
|
function csvToMarkdown(csvContent, delimiter = ",", hasHeader = true) {
|
|
if (delimiter != "\t") {
|
|
csvContent = csvContent.replace(/\t/g, " ");
|
|
}
|
|
const columns = csvContent.split(/\r?\n/);
|
|
const tabularData = [];
|
|
const maxRowLen = [];
|
|
columns.forEach((e, i) => {
|
|
if (typeof tabularData[i] == "undefined") {
|
|
tabularData[i] = [];
|
|
}
|
|
const regex = new RegExp(delimiter + '(?![^"]*"\\B)');
|
|
const row = e.split(regex);
|
|
row.forEach((ee, ii) => {
|
|
if (typeof maxRowLen[ii] == "undefined") {
|
|
maxRowLen[ii] = 0;
|
|
}
|
|
// escape pipes and backslashes
|
|
ee = ee.replace(/(\||\\)/g, "\\$1");
|
|
maxRowLen[ii] = Math.max(maxRowLen[ii], ee.length);
|
|
tabularData[i][ii] = ee;
|
|
});
|
|
});
|
|
let headerOutput = "";
|
|
let seperatorOutput = "";
|
|
maxRowLen.forEach((len) => {
|
|
const sizer = Array(len + 1 + 2);
|
|
seperatorOutput += "|" + sizer.join("-");
|
|
headerOutput += "|" + sizer.join(" ");
|
|
});
|
|
headerOutput += "| \n";
|
|
seperatorOutput += "| \n";
|
|
if (hasHeader) {
|
|
headerOutput = "";
|
|
}
|
|
let rowOutput = "";
|
|
tabularData.forEach((col, i) => {
|
|
maxRowLen.forEach((len, y) => {
|
|
const row = typeof col[y] == "undefined" ? "" : col[y];
|
|
const spacing = Array((len - row.length) + 1).join(" ");
|
|
const out = `| ${row}${spacing} `;
|
|
if (hasHeader && i === 0) {
|
|
headerOutput += out;
|
|
}
|
|
else {
|
|
rowOutput += out;
|
|
}
|
|
});
|
|
if (hasHeader && i === 0) {
|
|
headerOutput += "| \n";
|
|
}
|
|
else {
|
|
rowOutput += "| \n";
|
|
}
|
|
});
|
|
return `\n\n ${headerOutput}${seperatorOutput}${rowOutput} \n\n`;
|
|
}
|
|
exports.csvToMarkdown = csvToMarkdown;
|
|
//# sourceMappingURL=tables.js.map
|