2e:null 2f:["$","title",null,{"children":"SIPC - Separar datos de que incluyan un \\`${delimitador}\\` | Brian J. Cardiff | Observable"}] 34:[] 32:{"id":"416ef7e568012589","slug":"sipc-separar-datos-de-que-incluyan-un-delimitador","title":"SIPC - Separar datos de que incluyan un \\`${delimitador}\\`","thumbnail":"9f9209d806ee5366bab4083eee0e22ef1ec6311f17e55f84bdca6f60a2c43517","access_level":"public","create_time":"$D2018-03-21T21:33:39.224Z","update_time":"$D2018-03-22T04:14:36.696Z","view_time":null,"first_public_time":"$D2018-03-22T04:08:56.399Z","has_unpublished_edits":null,"fork":{"id":"bb6f561d9724a5c8","slug":"reemplazar-por-n-en-csv-exportar-con","title":"SIPC - Reemplazar # por Ñ en csv. Exportar con \\`,\\`","owner":{"id":"e21daad72cefad47","login":"bcardiff","name":"Brian J. Cardiff"}},"stars":0,"starred":false,"owner":{"type":"team","id":"e21daad72cefad47","login":"bcardiff","name":"Brian J. Cardiff","avatar_url":"https://avatars-next.observableusercontent.com/0abf5b5392695f4aaaf5d28cc4b279e7824e11bc88a7b1368809350db927c833","tier":"starter_2024"},"version":315,"publish_version":315,"role":null,"authored":false,"authors":[{"type":"individual","id":"9bdeca5f4bd953fa","login":"bcardiff","name":"Brian J. Cardiff","avatar_url":"https://avatars-next.observableusercontent.com/0abf5b5392695f4aaaf5d28cc4b279e7824e11bc88a7b1368809350db927c833","tier":null}],"members":[{"type":"individual","id":"9bdeca5f4bd953fa","login":"bcardiff","name":"Brian J. Cardiff","avatar_url":"https://avatars-next.observableusercontent.com/0abf5b5392695f4aaaf5d28cc4b279e7824e11bc88a7b1368809350db927c833","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":0,"collection":null,"type":"notebook","body":{"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","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":158,"value":"md`Poner el archivo \\`.csv\\` a continuación`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":25,"value":"viewof input = html``","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"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","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":163,"value":"md`Descargar el archivo curado presionando el siguiente botón`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":143,"value":"utils.papaparse.then(m => DOM.download(new Blob([m.unparse(flatten)]), output_name))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":151,"value":"html`\n

\nIgnorar desde acá\n

\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":268,"value":"delimitador = \";\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":314,"value":"output_name = input.name.replace(/\\.csv$/, \"-separados.csv\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"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","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"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","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":236,"value":"splitted = csv.data.map(row => row.map(cell => cell.split(delimitador)))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":55,"value":"csv = Files.text(input).then(content => utils.papaparse.then(m => m.parse(content)))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"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","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W34","stdlib":"1","titling":"auto"}} 33:"$32:body"