2c:null 2d:["$","title",null,{"children":"DataT | Guilherme Ranoya | Observable"}] 32:T610,imagefromallsources = function (kurl) { // FUNÇÃO IMAGE FROM ALL SOURCES let saida = kurl; let murl = kurl; if (kurl.match(/(\&$)/gm)) { murl = kurl.replace(/(\&$)/gm, ""); } if (murl.match(/https:\/\/drive\.google\.com\/open\?(.*)/i)) { let complementa = murl.match( /https:\/\/drive\.google\.com\/open\?id=(.*)/i )[1]; /* OLD saida = "https://drive.google.com/uc?export=view&" + complementa + "&usp=drive_fs"; */ saida = "https://lh3.googleusercontent.com/d/" + complementa; } if (murl.match(/https:\/\/drive\.google\.com\/file\/d/i)) { let complementa = murl.match( /https:\/\/drive\.google\.com\/file\/d\/(.*)\/view/i )[1]; /* OLD saida = "https://drive.google.com/uc?export=view&id=" + complementa + "&usp=drive_fs"; */ saida = "https://lh3.googleusercontent.com/d/" + complementa; } if (murl.match(/https:\/\/drive\.google\.com\/uc\?export=view/i)) { let complementa = murl.match(/id=(.*)/i)[1]; saida = "https://lh3.googleusercontent.com/d/" + complementa; } let nurl = murl.replace(/\&/gi, "&"); let video = nurl.match( /(http:|https:|)\/\/(player.|www.|m.)?(vimeo\.com|youtu(be\.com|\.be|be\.googleapis\.com))\/(video\/|embed\/|watch\?v=|v\/)?([A-Za-z0-9._%-]*)(\&\S+)?/ ); if (typeof video != "undefined" && video != null) { saida = "https://img.youtube.com/vi/" + video[6] + "/0.jpg"; } if (nurl.match(/\.png|\.svg|\.jpg|\.gif|.webp/i)) { saida = nurl; } return saida; }33:T8cc,imagetable = function (data, column, options) { let code = ""; let colnum = 4; let imgsize = "cover"; let aspect = "1/1"; let start = 0; let stop = data.length; if (typeof options != "undefined" && options != null && options != "") { if ( typeof options.columns != "undefined" && options.columns != null && options.columns != "" ) { colnum = options.columns; } if ( typeof options.type != "undefined" && options.type != null && options.type != "" ) { imgsize = options.type; } if ( typeof options.proportion != "undefined" && options.proportion != null && options.proportion != "" ) { aspect = options.proportion; } if ( typeof options.index != "undefined" && options.index != null && options.index != "" ) { start = options.index; } if (start > data.length) { start = data.length; } if ( typeof options.size != "undefined" && options.size != null && options.size != "" ) { stop = start + options.size; } if (stop >= data.length) { stop = data.length; } } let grd = ""; for (let k = 0; k < colnum; k++) { grd += " 1fr"; } code += `

`; for (let i = start; i < stop; i++) { code += `

`; } code += `

`; return html`${code}`; }34:T417,
### Sort by a list of values Sort an array using a list of possible values for a specific key ```js newarray = sortbylist(oldarray, keyvaluesarray, key); ```
Example: ```js disordered = [ {'fruit': 'orange', 'quantity': 5, 'type': 'B'}, {'fruit': 'apple', 'quantity': 2, 'type': 'A'}, {'fruit': 'banana', 'quantity': 3, 'type': 'B'}, {'fruit': 'apple', 'quantity': 10, 'type':'B'}, {'fruit': 'strawberry', 'quantity': 5, 'type': 'A'} ]; list = ['strawberry', 'apple']; orders = sortbylist(disordered, list, 'fruit'); // Array(3): // [ // {'fruit': 'strawberry', 'quantity': 5, 'type': 'A'}, // {'fruit': 'apple', 'quantity': 2, 'type': 'A'}, // {'fruit': 'apple', 'quantity': 10, 'type':'B'} // ] ```
35:T857,createtable = function (orignarr, ordenator, rev = false) { let orde = Object.keys(orignarr[0])[0]; let arr = []; if ( typeof ordenator != "undefined" && ordenator != "null" && ordenator != "" ) { arr = alphabetic(orignarr, ordenator); } else { arr = orignarr; } if (rev) { arr.reverse(); } let code = ` `; let fracs = ""; let tempcode = ""; let keys = Object.keys(arr[0]); for (let i = 0; i < keys.length - 1; i++) { fracs += " auto"; tempcode += `

${ keys[i + 1] }

`; } code += `

${keys[0]}

${tempcode}

`; for (let i = 0; i < arr.length; i++) { for (let c = 0; c < keys.length; c++) { code += `

${arr[i][keys[c]]}

`; } code += `

`; return html`${code}`; }36:[] 30:{"id":"56faae957b308034","slug":"datat","title":"DataT","thumbnail":"1eb89281e85400ce7fad981c8dd30c1267baf29655a9883b0a6e178cbee9c7e9","access_level":"public","create_time":"$D2021-11-13T19:41:13.453Z","update_time":"$D2026-03-29T13:56:49.421Z","view_time":null,"first_public_time":"$D2021-11-13T20:08:46.478Z","has_unpublished_edits":null,"fork":false,"stars":0,"starred":false,"owner":{"type":"team","id":"0a78bc4380cdd0f8","login":"ranoya","name":"Guilherme Ranoya","avatar_url":"https://avatars-next.observableusercontent.com/f2bd0349885993a7b110789aa4741bda605eb0a795d20940d586f0ced4c0f91a","tier":"starter_2024"},"version":918,"publish_version":null,"role":null,"authored":false,"authors":[{"type":"individual","id":"92bd7310c7ec23d5","login":"ranoya","name":"Guilherme Ranoya","avatar_url":"https://avatars-next.observableusercontent.com/f2bd0349885993a7b110789aa4741bda605eb0a795d20940d586f0ced4c0f91a","tier":null}],"members":[{"type":"individual","id":"92bd7310c7ec23d5","login":"ranoya","name":"Guilherme Ranoya","avatar_url":"https://avatars-next.observableusercontent.com/f2bd0349885993a7b110789aa4741bda605eb0a795d20940d586f0ced4c0f91a","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":0,"collection":{"id":"bc29e2fa5c3396f4","slug":"tools","title":"Tools","owner":{"id":"0a78bc4380cdd0f8","login":"ranoya","name":"Guilherme Ranoya"}},"type":"notebook","body":{"title":"DataT","cells":[{"id":0,"value":"# DataT\n## Tools for manipulating data in arrays and objects\n\nLibrary available at [https://datat.vercel.app/basics.js](https://datat.vercel.app/basics.js)","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":432,"value":"
\n### General Functions","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":15,"value":"
\n### Fetch JSON function, adapted for Observable\nGet a json from a URL\n\n```js\nxpto = getdata(myurl);\n```\n
\n**Original pure javascript DataT Fetch function:**\n

This is how the getdata is used in pure Javascript, outside Observable

\n\n```js\ngetdata(myurl, function(data) {\n // console.table(data);\n});\n```\n
","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":12,"value":"/*\n\n this getdata function works in observable, but throws an error in the definition here.\n it's prefereable to use D3 fetch instead.\n\n*/\n\n/* \n getdata = function (url) {\n let dados = fetch(url).then((response) => {\n return response.json();\n });\n\n return dados;\n}\n*/\n\ngetdata = d3.json","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":614,"value":"
\n### Fetch CSV function, adapted for Observable\nGet a csv from a URL\n\n```js\nxpto = getcsvdata(myurl);\n```\n
\n**Original pure javascript DataT Fetch function:**\n

This is how the getcsvdata is used in pure Javascript, outside Observable

\n\n```js\ngetcsvdata(myurl, function(data) {\n // console.table(data);\n});\n```\n
","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":612,"value":"/*\n\n Using D3 csv fetch because it's already loaded in Observable\n\n*/\n\ngetcsvdata = d3.csv","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":638,"value":"
\n##### Shortcut\n```js\nmydata = gsdata(myGoogleSheetURL);\n```\n\nExample:\n\n```js\nmydata = gsdata(\"https://docs.google.com/spreadsheets/d/1ih4V4CumuIl5ZynobsazNzGiaPrE2V2Dpt13FI22XNU/edit#gid=0\");\n```","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":635,"value":"gsdata = function (url) {\n return getcsvdata(GoogleSheetCsvURL(url));\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":451,"value":"
\n### Get a JSON output from a Google Sheet URL using opensheet.elk.sh\n*not recommended anymore: unfortunately some internet providers block or fail to load data from opensheet.elk.sh; use getcsvdata and GoogleSheetCsvURL instead.*\n\nReturn the correct URL for a JSON output from Google Sheets\n\n```js\nxpto = googlesheet(mygooglesheeturl,sheetname);\n```\n\nExample:\n\n```js\nlet myJsonURL = googlesheet('https://docs.google.com/spreadsheets/d/10wpfmMWn3igQF4rJBYCo8OR90igO1tfKwcmrot0ult0/edit#gid=0', 'CodeEditors');\n```\n\n
","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":624,"value":"
\n\n### Get a valid CSV URL from a Google Sheet URL\n\n`mydataurl = GoogleSheetCsvURL(url);`\n\nReturn a CSV URL from the provided Google Sheet URL\n\nExample:\n\n```js\nlet mycsvdataurl = GoogleSheetCsvURL('https://docs.google.com/spreadsheets/d/1ih4V4CumuIl5ZynobsazNzGiaPrE2V2Dpt13FI22XNU/edit#gid=0');\nlet data = getcsvdata(mycsvdataurl);\n```","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":443,"value":"GoogleSheetCsvURL = function (url) {\n url = new URL(url);\n const id = url.pathname.split(\"/\")[3];\n const gid = new URLSearchParams(url.hash.slice(1)).get(\"gid\") || 0;\n return `https://docs.google.com/spreadsheets/d/${id}/export?format=csv&gid=${gid}`;\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":645,"value":"
\n\n### Verify if it has data\n\nCheck if a variable exists/don't exists and has/don't have data in it\n\n`hasdata = notempty(mydata[0].name);`\n\n`empty`: Return true if variable has not data or do not exists, and false otherwise\n`notempty`: Return true if a variable exists and has data, and false otherwise\n\nExample:\n\n```js\nif(empty(mydata)) {\n // do something\n } else {\n // do something else\n }\n```","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":641,"value":"empty = function (myvar) {\n if (typeof myvar == \"undefined\" || myvar == \"\" || myvar == null) {\n return true;\n } else {\n return false;\n }\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":643,"value":"notempty = function (myvar) {\n if (typeof myvar != \"undefined\" && myvar != \"\" && myvar != null) {\n return true;\n } else {\n return false;\n }\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":423,"value":"
\n\n### Get images from any kind of url\n(under improvement)\n\n`xpto = imagefromallsources(url);`\n\nReturn the url for an image.\nIf it is already an image, return the url;\nIf it is a video, return the url from the thumnail.\n\nExample:\n\n```js\nlet photo = imagefromallsources('https://www.youtube.com/watch?v=ZbFATmGhz9k');\n```","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":420,"value":"$32","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":721,"value":"
\n\n### Create tables with images\n\n`mytable = imagetable(data, image_column_name, {options});`\n\nCreate a configurable table to show a collection of images.\n\nFor `{options}`, we have:\n\n|property | type | description | example |\n|---|---|---|---|\n| columns | number | number of columns | 12 |\n| type | string | CSS type of background | \"contain\" or \"cover\" |\n| proportion | string | Aspect-ratio for the table cells | \"16/9\" |\n| index | number | Where to start in the data | 10 |\n| size | number | How many images to show | 5 |\n\nIf `index` is not specified, `imagetable` will start at `0`.\n\nIf `size` is not specified, `imagetable` will end at the last registry available.\n\nExample:\n\n```js\nlet allimages = datatable(arr, \"images_url\", { columns: 6, proportion: \"4/3\"});\n```\n\nThe table can be styled with the CSS class `.datat_imagetable` and the cells with the CSS class `.datat_imagetable_images`.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":659,"value":"$33","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":144,"value":"
\n### Date functions\n
\n\n##### dayadd - add days to a string date\n```js\nxpto = dayadd(originaldate, days);\n```\n\nExample:\n\n```js\nmystringdate = \"11/04/2022\";\nnewdate = dayadd(mystringdate, 7);\n```","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":153,"value":"dayadd = function (data, dias) {\n let dataAjustada = data\n .replace(/(\\d+)\\/(\\d+)\\/(\\d\\d\\d\\d)/g, \"$3-$2-$1\")\n .toString();\n\n let result = new Date(dataAjustada);\n\n result.setDate(result.getDate() + (dias + 1));\n\n let ajustaresult =\n result.getDate() +\n \"/\" +\n (result.getMonth() + 1) +\n \"/\" +\n result.getFullYear();\n return ajustaresult;\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":218,"value":"
\n##### howmanydays - how many days passed between two dates, including the last one\n```js\nday = howmanydaysincluding(firstdate, seconddate);\n```\n\nExample:\n\n```js\ndayspassed = howmanydaysincluding(\"11/04/2022\", \"15/04/2022\");\n```","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":223,"value":"howmanydaysincluding = function (dataB, dataA) {\n let dataAjustada = dataA\n .replace(/(\\d+)\\/(\\d+)\\/(\\d\\d\\d\\d)/g, \"$3-$2-$1\")\n .toString();\n\n let dataBjustada = dataB\n .replace(/(\\d+)\\/(\\d+)\\/(\\d\\d\\d\\d)/g, \"$3-$2-$1\")\n .toString();\n\n let resultA = new Date(dataAjustada);\n let resultB = new Date(dataBjustada);\n\n let resultC = Math.abs(resultA - resultB);\n\n return resultC / (1000 * 3600 * 24) + 1;\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":527,"value":"
\n### Re-escale\nCreate a function that recalculates a value in a different scale\n\n```js\nnewfunction = rescale([originallimit_1,originallimit_2],[conversionlimit_1,conversionlimit_2]);\n```\n
\nExample:\n```js\nconst y = rescale([0,1],[50,70]);\nlet xpto = y(0.5); // = 60\n```\n\n
","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":535,"value":"rescale = function ([a, b], [c, d]) {\n return function (e) {\n return ((e - a) / (b - a)) * (d - c) + c;\n };\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":868,"value":"
\n### Between Filter\nCreate a list array from an old one when the values in the specified column are between the the limits of the query\n\n```js\nxpto = btwfilter(array, column, query)\n```\n
\nExample:\n```js\nbest = btwfilter(oldarray, \"ranking\", \"> 9.5\");\neighties = btwfilter(oldarray, \"year\", \"1980 > 1989\");\n```\n\n
","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":844,"value":"btwfilter = function (arr, col, fi) {\n let di = -999999999999999999999;\n let df = 9999999999999999999999;\n\n let opera = \"\";\n\n if (\n fi.match(\n /\\-{0,1}\\d{1,20}\\.{0,1}\\d{0,20}.{0,2}\\>.{0,2}\\-{0,1}\\d{1,20}\\.{0,1}\\d{0,20}/gi\n )\n ) {\n opera = fi.match(/\\-{0,1}\\d{1,20}\\.{0,1}\\d{0,20}/gi);\n di = opera[0];\n df = opera[1];\n } else if (fi.match(/\\-{0,1}\\d{1,20}\\.{0,1}\\d{0,20}.{0,2}\\>/gi)) {\n opera = fi.match(/\\-{0,1}\\d{1,20}\\.{0,1}\\d{0,20}/gi);\n di = opera[0];\n } else if (fi.match(/\\>.{0,2}\\-{0,1}\\d{1,20}\\.{0,1}\\d{0,20}/gi)) {\n opera = fi.match(/\\-{0,1}\\d{1,20}\\.{0,1}\\d{0,20}/gi);\n df = opera[0];\n }\n\n let newarr = [];\n let c = 0;\n\n for (let i = 0; i < arr.length; i++) {\n if (\n parseFloat(arr[i][col]) >= parseFloat(di) &&\n parseFloat(arr[i][col]) <= parseFloat(df)\n ) {\n newarr[c] = arr[i];\n c++;\n }\n }\n\n return newarr;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":131,"value":"
\n### Boolean Filter\nCreate a list array from an old one when their elements have any value on a specific criteria(key)\n\n```js\nxpto = bfilter(array, criteria)\n```\n
\nExample:\n```js\nseparate = bfilter(oldarray, \"active\");\n```\n\n
","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":136,"value":"bfilter = function (arr, crit) {\n let newarr = [];\n let c = 0;\n for (let k = 0; k < arr.length; k++) {\n if (arr[k][crit] != \"\" && arr[k][crit] != undefined) {\n newarr[c] = {};\n newarr[c] = arr[k];\n c++;\n }\n }\n return newarr;\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":497,"value":"
\n### Conditional Filter\nCreate a list array from an old one when a specific key have a match of a specific value/pattern\n\n```js\nxpto = cfilter(array, key, pattern)\n```\n
\nExample:\n```js\nseparate = cfilter(oldarray, \"status\", \"(.*)ok\");\n```\n\n
","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":494,"value":"cfilter = function (arr, crit, regex) {\n let newarr = [];\n\n let patt = new RegExp(regex, \"i\");\n\n let c = 0;\n for (let k = 0; k < arr.length; k++) {\n if (\n arr[k][crit] != \"\" &&\n arr[k][crit] != undefined &&\n patt.test(arr[k][crit])\n ) {\n newarr[c] = {};\n newarr[c] = arr[k];\n c++;\n }\n }\n return newarr;\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":649,"value":"
\n### Sum Two Arrays\nCreate a new array adding the contents of other two arrays\n\n```js\nxpto = sumarray(arrayA, arrayB)\n```\n
\nExample:\n```js\nallnames = sumarray(oldnames, newnames);\n```\n\n
","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":647,"value":"sumarray = function (arr1, arr2) {\n let arr3 = [];\n let c = 0;\n\n for (let i = 0; i < arr1.length; i++) {\n arr3[c] = arr1[i];\n c++;\n }\n\n for (let k = 0; k < arr2.length; k++) {\n arr3[c] = arr2[k];\n c++;\n }\n\n return arr3;\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":654,"value":"sumarrayc = function (arr1, arr2) {\n let arr3 = [];\n let c = 0;\n\n for (let i = 0; i < arr1.length; i++) {\n arr3[c] = arr1[i];\n c++;\n }\n\n for (let k = 0; k < arr2.length; k++) {\n arr3[c] = arr2[k];\n c++;\n }\n\n let kes = [];\n\n for (let i = 0; i < arr3.length; i++) {\n for (let k in arr3[i]) {\n kes[k] = true;\n }\n }\n\n let ks = [];\n let ck = 0;\n\n for (let n in kes) {\n ks[ck] = n;\n ck++;\n }\n\n let arr4 = [];\n\n for (let n = 0; n < arr3.length; n++) {\n arr4[n] = {};\n for (let s = 0; s < ks.length; s++) {\n if (\n typeof arr3[n][ks[s]] == `undefined` ||\n arr3[n][ks[s]] == null ||\n arr3[n][ks[s]] == \"\"\n ) {\n arr4[n][ks[s]] = \"\";\n } else {\n arr4[n][ks[s]] = arr3[n][ks[s]];\n }\n }\n }\n\n return arr4;\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":831,"value":"
\n### Array Subtract\nSubtract the data present in one array if it exists in another array\n\n```js\nxpto = aSubtract(arrayA, arrayB)\n```\n
\nExample:\n```js\nnotconfirmedyet = aSubtract(allnames, confirmednames);\n```\n\n
","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":829,"value":"aSubtract = function (arr1, arr2) {\n var array = [];\n var c = 0;\n\n for (let i1 = 0; i1 < arr1.length; i1++) {\n let temp = false;\n\n for (let i2 = 0; i2 < arr2.length; i2++) {\n if (arr1[i1] == arr2[i2]) {\n temp = true;\n }\n }\n\n if (temp == false) {\n array[c] = arr1[i1];\n c++;\n }\n }\n\n return array;\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":887,"value":"
\n### Trim function\nRemove empty values from a array\n\n```js\nnewarray = trim(array);\n```\n
","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":885,"value":"trim = function (arr) {\n let newarr = [];\n let c = 0;\n for (let i = 0; i < arr.length; i++) {\n if (typeof arr[i] != \"undefined\" && arr[i] != null && arr[i] != \"\") {\n newarr[c] = arr[i];\n c++;\n }\n }\n return newarr;\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":84,"value":"
\n### Unique function\nList of unique values from a criteria (key) in the array\n\n```js\nnewarray = unique(oldarray, criteria);\n```\n
","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":89,"value":"unique = function (arr, crit) {\n let newarr = [];\n\n for (let i = 0; i < arr.length; i++) {\n newarr[arr[i][crit]] = 0;\n }\n\n let list = [];\n\n for (let key in newarr) {\n list.push(key);\n }\n\n return list;\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":917,"value":"uniqueandtrim = function (arr, crit) {\n let newarr = [];\n\n for (let i = 0; i < arr.length; i++) {\n if (\n typeof arr[i][crit] != \"undefined\" &&\n arr[i][crit] != \"\" &&\n arr[i][crit] != null\n ) {\n newarr[arr[i][crit]] = 0;\n }\n }\n\n let list = [];\n\n for (let key in newarr) {\n list.push(key);\n }\n\n return list;\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":110,"value":"$34","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":106,"value":"sortbylist = function (arr, list, crit) {\n let newarr = [];\n\n for (let l = 0; l < list.length; l++) {\n for (let a = 0; a < arr.length; a++) {\n if (arr[a][crit] == list[l]) {\n newarr.push(arr[a]);\n }\n }\n }\n\n return newarr;\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":594,"value":"
\n### Sort by alphabetic order\nSort an array in alphabetic order over the values for a specific key\n\n```js\nnewarray = alphabetic(oldarray, key);\n```\n
\nExample:\n\nstudents = alphabetic(list, 'name'); \n\n```\n
","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":597,"value":"alphabetic = function (arr, crit) {\n let listuniques = unique(arr, crit);\n\n let allnumbers = true;\n for (let i = 0; i < arr.length; i++) {\n if (!Number.isFinite(arr[i][crit])) {\n allnumbers = false;\n }\n }\n\n if (allnumbers) {\n listuniques.sort(function (a, b) {\n return a - b;\n });\n } else {\n listuniques.sort();\n }\n\n let newarr = sortbylist(arr, listuniques, crit);\n\n return newarr;\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":126,"value":"
\n### Extract all Tags\nExtract all Tags (words marking some criteria) in an array of objects, in a specific key\nof the object\n\n```js\nnewarray = tags(array, key, separator);\n```\n
\nExample:\n```js\nalltags = tags(myarray, \"categories\", \",\"); \n```\n
","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":118,"value":"tags = function (arr, crit, separator) {\n let narr = [];\n let expl = [];\n\n for (let p = 0; p < arr.length; p++) {\n expl = [];\n expl = arr[p][crit].split(separator);\n\n for (let z = 0; z < expl.length; z++) {\n narr.push(expl[z]);\n }\n }\n\n let newarr = [];\n\n for (let i = 0; i < narr.length; i++) {\n newarr[narr[i]] = 0;\n }\n\n let list = [];\n\n for (let key in newarr) {\n list.push(key);\n }\n\n return list;\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":475,"value":"
\n### Shuffle function:\nCreate a list of numbers without repetition, for random ordering itens of a list\n\n```js\nneworderarray = shuffle(maxvalue, listsize);\n```\n
\nExample:\n```js\norder = suffle(myarray.length, 10); \n```\n\n
","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":467,"value":"shuffle = function (maxvalue, listsize) {\n let lista = [];\n let c = 0;\n let r = false;\n let n = 0;\n\n while (c < listsize) {\n n = parseInt(Math.random() * maxvalue);\n\n r = false;\n for (let i = 0; i < lista.length; i++) {\n if (n == lista[i]) {\n r = true;\n }\n }\n\n if (!r) {\n lista[lista.length] = n;\n c++;\n }\n }\n\n return lista;\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":24,"value":"
\n### Select function:\nCreate a filtered array using a function to filter data\n\n```js\nnewarray = select(oldarray, function (n, arr, patt) {\n\n // if(patt.test(arr.valr)) {\n // n.push(arr);\n // }\n\n}, patt);\n```\n
\nUsing Select Predefined Tools:\n\n```\nnewarray = select(oldarray,patterncheck,/mypattern/gi);\n\n```\n
","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":22,"value":"select = function (arr, fun, arr2) {\n let newarr = [];\n\n for (let i = 0; i < arr.length; i++) {\n fun(newarr, arr[i], arr2);\n }\n\n return newarr;\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":38,"value":"
\n#### Select Predefined Tools\nFunctions to pair with Select Function\n
","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":307,"value":"Simple pattern (regex) check
\nCheck if a given pattern is present\n\nEx:\n```js\nnewarray = select(oldarray,patterncheck,/mypattern/gi);\n```","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":47,"value":"patterncheck = function (n, arr, patt) {\n let mark = false;\n\n for (let k = 0; k < Object.keys(arr).length; k++) {\n if (patt.test(arr[Object.keys(arr)[k]])) {\n mark = true;\n }\n }\n\n if (mark) {\n n.push(arr);\n }\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":542,"value":"selectp = function (oldarray, patt) {\n return select(oldarray, patterncheck, patt);\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":311,"value":"Additive multipattern check
\nInclude any finding of any patterns separated by space\n\nEx:\n```js\nnewarray = select(oldarray, multipatterncheck_add, \"slide presentation document\");\n```","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":295,"value":"multipatterncheck_add = function (n, arr, patt) {\n if (patt != \"\" || typeof patt != \"undefined\") {\n let mark = false;\n let multipatt = patt.split(\" \");\n let regextrans = \"\";\n\n for (let m = 0; m < multipatt.length; m++) {\n for (let k = 0; k < Object.keys(arr).length; k++) {\n regextrans = new RegExp(multipatt[m], \"i\");\n if (regextrans.test(arr[Object.keys(arr)[k]])) {\n mark = true;\n }\n }\n }\n\n if (mark) {\n n.push(arr);\n }\n } else {\n n.push(arr);\n }\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":540,"value":"selecta = function (oldarray, str) {\n return select(oldarray, multipatterncheck_add, str);\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":319,"value":"Exclusion multipattern check
\nInclude findings when all patterns separated by space are present\n\nEx:\n```js\nnewarray = select(oldarray, multipatterncheck_exclude, \"slide class\");\n```","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":318,"value":"multipatterncheck_exclude = function (n, arr, patt) {\n if (patt != \"\" || typeof patt != \"undefined\") {\n let multipatt = patt.split(\" \");\n let regextrans = \"\";\n let allcheck = [];\n let mark = true;\n\n for (let i = 0; i < multipatt.length; i++) {\n allcheck[multipatt[i]] = false;\n }\n\n for (let k = 0; k < Object.keys(arr).length; k++) {\n for (let m = 0; m < multipatt.length; m++) {\n regextrans = new RegExp(multipatt[m], \"i\");\n if (regextrans.test(arr[Object.keys(arr)[k]])) {\n allcheck[multipatt[m]] = true;\n }\n }\n }\n\n for (let i = 0; i < multipatt.length; i++) {\n if (allcheck[multipatt[i]] == false) {\n mark = false;\n }\n }\n\n if (mark) {\n n.push(arr);\n }\n } else {\n n.push(arr);\n }\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":537,"value":"selecte = function (oldarray, str) {\n return select(oldarray, multipatterncheck_exclude, str);\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":787,"value":"

\n### Observable Specific","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":730,"value":"setinput = function (input, value) {\n input.value = value;\n input.dispatchEvent(new Event(\"input\", { bubbles: true }));\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":736,"value":"createbuttons = function (input, labels, values) {\n if (typeof values == \"undefined\" || values == null || values == \"\") {\n values = labels;\n }\n\n let buttons = [];\n let c = 0;\n\n for (let i = 0; i < values.length; i++) {\n if (labels[i] != \"\" && labels[i] != null) {\n buttons[c] = html`\n\n \n\n

${labels[i]}

`;\n\n buttons[c].onclick = function () {\n setinput(input, values[i]);\n };\n c++;\n }\n }\n\n return html`${buttons}`;\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":915,"value":"$35","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W36","stdlib":"1","titling":"auto"}} 31:"$30:body"