30:[] 2e:{"title":"Table Extractor","cells":[{"id":0,"value":"md`# Table Extractor\n\nfor tiny datasets in html tables.\n\nRecommended usage:\n~~~js\nimport {tableView} from \"@fil/table-extractor\"\n\nviewof c = tableView(md\\`\n| field1 | field2 |\n|---\n| value 1 | value 2 |\n\\`)\n~~~\n\n(Note that this is not yet stabilized, I may change the API any time, so fork it, or pin the version if you use it for real.)`","pinned":false,"hidden":false,"mode":"ojs"},{"id":92,"value":"md`## Examples`","pinned":false,"hidden":false,"mode":"ojs"},{"id":98,"value":"md`### Usage with viewof:`","pinned":false,"hidden":false,"mode":"ojs"},{"id":40,"value":"// use as a viewof (single table) on markdown or html markup\nviewof c = tableView(md`| date | name | value |\n|---\n| 22.01 | Julie | $3 |\n| 24.01 | Ahmad | $13 |\n| 25.01 | Baruch | $2 |\n`)","pinned":true,"hidden":false,"mode":"ojs"},{"id":59,"value":"c","pinned":true,"hidden":false,"mode":"ojs"},{"id":101,"value":"md`### Usage in a function:`","pinned":false,"hidden":false,"mode":"ojs"},{"id":15,"value":"a = html`

date	name	value
22.01	Julie	$3
24.01	Ahmad	$13
25.01	Baruch	$2

`","pinned":true,"hidden":false,"mode":"ojs"},{"id":10,"value":"// extract one table\ntableExtractor(a)","pinned":true,"hidden":false,"mode":"ojs"},{"id":30,"value":"b = md`_two tables of tiny data_\n\n| date | name | value |\n|---\n| 22.01 | Julie | $3 |\n| 24.01 | Ahmad | $13 |\n| 25.01 | Baruch | $2 |\n\n| date | name | value |\n|---\n| 22.01 | Julie | $3 |\n| 24.01 | Ahmad | $13 |\n| 25.01 | Baruch | $2 |\n`","pinned":false,"hidden":false,"mode":"ojs"},{"id":32,"value":"// extract several tables\ntableExtractor(b, true)","pinned":true,"hidden":false,"mode":"ojs"},{"id":26,"value":"// extract all the tables in the document\n(a, b, tableExtractor(d3.selectAll(\"table\"), true))","pinned":true,"hidden":false,"mode":"ojs"},{"id":105,"value":"md`### Processing external data?\n\nIt's not meant for that, but why not.`","pinned":false,"hidden":false,"mode":"ojs"},{"id":107,"value":"fetch(CORS_PROXY + \"https://en.wikipedia.org/wiki/List_of_sandwiches\")\n .then((resp) => resp.text())\n .then((html) => d3.create(\"div\").html(html))\n .then(tableExtractor)","pinned":true,"hidden":false,"mode":"ojs"},{"id":127,"value":"md`## Code`","pinned":false,"hidden":false,"mode":"ojs"},{"id":3,"value":"tableExtractor = (root, multiple = false) => {\n const T = [];\n if (!root || !root.selectAll) root = d3.select(root);\n const tables = root\n .filter(function() {\n return this.nodeName === \"TABLE\";\n })\n .size()\n ? root.nodes()\n : root.selectAll(\"table\");\n\n for (const table of tables) {\n const keys = [],\n rows = [];\n for (const th of d3.select(table).selectAll(\"th\")) {\n keys.push(th.innerText.trim());\n }\n for (const tr of d3\n .select(table)\n .select(\"tbody\")\n .selectAll(\"tr\")) {\n // if we haven't found a thead, number keys\n if (keys.length === 0) {\n d3.select(tr)\n .selectAll(\"td\")\n .each((_, i) => keys.push(i));\n }\n const row = {};\n let i = 0;\n for (const td of d3.select(tr).selectAll(\"td\")) {\n const k = keys[i++];\n if (k) row[k] = td.innerText.trim();\n }\n rows.push(row);\n }\n rows.columns = keys;\n if (keys.length) T.push(rows);\n }\n return multiple ? T : T[0];\n}","pinned":true,"hidden":false,"mode":"ojs"},{"id":50,"value":"tableView = (element, multiple) => {\n return Object.assign(element, { value: tableExtractor(element, multiple) });\n}","pinned":true,"hidden":false,"mode":"ojs"},{"id":6,"value":"d3 = require(\"d3-selection@2\")","pinned":true,"hidden":false,"mode":"ojs"},{"id":157,"value":"// import { CORS_PROXY } from \"@fil/cors-proxy\"\nCORS_PROXY = \"https://cors-anywhere.herokuapp.com/\"","pinned":true,"hidden":false,"mode":"ojs"}],"files":"$W30","stdlib":"1","titling":"auto"}