31:[] 2f:{"title":"SIPC - Separar datos de que incluyan un \\`${delimitador}\\`","cells":[{"id":0,"value":"md`# SIPC - Separar datos de que incluyan un \\`${delimitador}\\``","pinned":false,"hidden":false,"mode":"ojs"},{"id":158,"value":"md`Poner el archivo \\`.csv\\` a continuación`","pinned":false,"hidden":false,"mode":"ojs"},{"id":25,"value":"viewof input = html``","pinned":false,"hidden":false,"mode":"ojs"},{"id":277,"value":"html`

Un ejemplo de los datos leídos

\n\n

\n ${flatten.slice(0).slice(0, 5).map(row => html`\n ${row.map(cell => html``)}\n `)}\n

${cell}

`","pinned":false,"hidden":false,"mode":"ojs"},{"id":163,"value":"md`Descargar el archivo curado presionando el siguiente botón`","pinned":false,"hidden":false,"mode":"ojs"},{"id":143,"value":"utils.papaparse.then(m => DOM.download(new Blob([m.unparse(flatten)]), output_name))","pinned":false,"hidden":false,"mode":"ojs"},{"id":151,"value":"html`\n

\nIgnorar desde acá\n

\n`","pinned":false,"hidden":false,"mode":"ojs"},{"id":268,"value":"delimitador = \";\"","pinned":false,"hidden":false,"mode":"ojs"},{"id":314,"value":"output_name = input.name.replace(/\\.csv$/, \"-separados.csv\")","pinned":false,"hidden":false,"mode":"ojs"},{"id":238,"value":"cols_per_col = {\n const res = new Array(splitted[0].length)\n res.fill(0)\n splitted.forEach(row => row.forEach((cell, col) => { res[col] = Math.max(res[col], cell.length) }))\n return res\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":258,"value":"flatten = splitted.map(row => utils.array_flatten(row.map((cell, col) => utils.array_pad(cell, cols_per_col[col]))))","pinned":false,"hidden":false,"mode":"ojs"},{"id":236,"value":"splitted = csv.data.map(row => row.map(cell => cell.split(delimitador)))","pinned":false,"hidden":false,"mode":"ojs"},{"id":55,"value":"csv = Files.text(input).then(content => utils.papaparse.then(m => m.parse(content)))","pinned":false,"hidden":false,"mode":"ojs"},{"id":17,"value":"utils = {\n return {\n papaparse: require(\"papaparse\"),\n array_flatten: (arr_of_arr) => {\n const res = new Array()\n arr_of_arr.forEach(arr => {\n Array.prototype.push.apply(res, arr)\n })\n return res\n },\n array_pad: (arr, length) => {\n const res = arr.slice(0) // duplicate arr\n const to_add = new Array(length - arr.length)\n to_add.fill(\"\")\n Array.prototype.push.apply(res, to_add)\n return res \n }\n }\n}","pinned":false,"hidden":false,"mode":"ojs"}],"files":"$W31","stdlib":"1","titling":"auto"}