30:[] 2e:{"title":"Test Data Crib Sheet","cells":[{"id":0,"value":"md`# Test Data Crib Sheet\n\nSimple document for generating strings of test data and converting Excel formatted cells to formats more conducive to copy paste.\n`","pinned":false,"hidden":false,"mode":"ojs"},{"id":221,"value":"md`## Convert CSV Rows/Cols to JSON`","pinned":false,"hidden":false,"mode":"ojs"},{"id":200,"value":"viewof queryCSVtoJSON = textarea({\n title: \"Paste Multi-Valued Excel Cell\",\n value:\n \"foo,bar,baz\\n1,2,3\",\n width: \"80%\",\n rows: 10,\n submit: \"Transform\"\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":209,"value":"jsonData = {\n return papa.parse(queryCSVtoJSON,{header: true})\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":214,"value":"textarea({\n title: \"Paste Multi-Valued Excel Cell\",\n value:JSON.stringify(jsonData.data,null,2),\n width: \"80%\",\n rows: 10\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":183,"value":"md`## Convert Multi-Valued Cell to Comma Delimited Array of Strings`","pinned":false,"hidden":false,"mode":"ojs"},{"id":147,"value":"viewof query = textarea({\n title: \"Paste Multi-Valued Excel Cell\",\n value:\n \"a\\nb\\nc\\n\",\n width: \"80%\",\n rows: 10,\n submit: \"Transform\"\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":155,"value":"answer = {\n const regex = /(.+)\\n/g;\n return query.replaceAll(regex, \"\\\"$1\\\",\")\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":151,"value":"viewof clean = textarea({\n title: \"Results\",\n value:answer,\n width: \"80%\",\n rows: 10\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":186,"value":"md`## Convert Column Names to Comma Delimited Array of Strings`","pinned":false,"hidden":false,"mode":"ojs"},{"id":170,"value":"viewof queryColumns = textarea({\n title: \"Paste Multi-Column Cells\",\n value:\n \"a\\tb\\tc\",\n width: \"80%\",\n rows: 10,\n submit: \"Transform\"\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":172,"value":"answerCols = {\n const regex = /([a-zA-Z0-9_]+)(\\t|,)?/g;\n return queryColumns.replaceAll(regex, \"\\\"$1\\\",\\n\")\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":174,"value":"viewof cleanCols = textarea({\n title: \"Results\",\n value:answerCols,\n width: \"80%\",\n rows: 10\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":197,"value":"md`## Random Strings`","pinned":false,"hidden":false,"mode":"ojs"},{"id":119,"value":"md`### 40 (Letters + Numbers)`","pinned":false,"hidden":false,"mode":"ojs"},{"id":115,"value":"{\n let chars = letters.concat(digits);\n let s = \"\"\n for(let i = 0; i < 40; ++i){\n s += chars[Math.floor(Math.random() * chars.length)];\n }\n return s;\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":27,"value":"md`### 100 (Letters + Numbers)`","pinned":false,"hidden":false,"mode":"ojs"},{"id":23,"value":"{\n let chars = letters.concat(digits);\n let s = \"\"\n for(let i = 0; i < 100; ++i){\n s += chars[Math.floor(Math.random() * chars.length)];\n }\n return s;\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":39,"value":"md`### 101 (Letters + Numbers)`","pinned":false,"hidden":false,"mode":"ojs"},{"id":43,"value":"{\n let s = \"\"\n for(let i = 0; i < 101; ++i){\n s += chars[Math.floor(Math.random() * chars.length)];\n }\n return s;\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":64,"value":"md`### 250 (Letters + numbers)`","pinned":false,"hidden":false,"mode":"ojs"},{"id":47,"value":"{\n let s = \"\"\n for(let i = 0; i < 250; ++i){\n s += chars[Math.floor(Math.random() * chars.length)];\n }\n return s;\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":107,"value":"md`### 1000 (Letters + numbers)`","pinned":false,"hidden":false,"mode":"ojs"},{"id":103,"value":"{\n let s = \"\"\n for(let i = 0; i < 1000; ++i){\n s += chars[Math.floor(Math.random() * chars.length)];\n }\n return s;\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":136,"value":"md`### 2000 (Letters + numbers)`","pinned":false,"hidden":false,"mode":"ojs"},{"id":132,"value":"{\n let s = \"\"\n for(let i = 0; i < 2000; ++i){\n s += chars[Math.floor(Math.random() * chars.length)];\n }\n return s;\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":67,"value":"md`### 4000 (Letters + numbers)`","pinned":false,"hidden":false,"mode":"ojs"},{"id":51,"value":"{\n let s = \"\"\n for(let i = 0; i < 4000; ++i){\n s += chars[Math.floor(Math.random() * chars.length)];\n }\n return s;\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":95,"value":"md`## Character List (modify to update)`","pinned":false,"hidden":false,"mode":"ojs"},{"id":77,"value":"chars = {\n return letters.concat(digits);\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":90,"value":"md`# Character Sets`","pinned":false,"hidden":false,"mode":"ojs"},{"id":4,"value":"lettersUpper = {\n let vals = [];\n for(let i = 65; i <= 90; ++i){\n vals.push(String.fromCharCode(i));\n }\n return vals;\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":10,"value":"lettersLower = {\n let vals = [];\n for(let i = 97; i <= 122; ++i){\n vals.push(String.fromCharCode(i));\n }\n return vals;\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":21,"value":"digits = {\n let vals = [];\n for(let i = 48; i <= 57; ++i){\n vals.push(String.fromCharCode(i));\n }\n return vals;\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":16,"value":"letters = {\n return lettersUpper.concat(lettersLower);\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":143,"value":"md`# Imports`","pinned":true,"hidden":false,"mode":"ojs"},{"id":141,"value":"import { textarea } from \"@jashkenas/inputs\"","pinned":true,"hidden":false,"mode":"ojs"},{"id":204,"value":"papa = require(\"papaparse\")","pinned":false,"hidden":false,"mode":"ojs"}],"files":"$W30","stdlib":"1","titling":"auto"}