karlpokus

# simple string
SET name "fido"
GET name 	// "fido"

# increment
SET connections 10
INCR connections	// 11
DEL connections		// deleted
INCR connections	// 1

karlpokus

# http://thepythonguru.com/

# start
$ python3

# end
$ exit()

# run
$ python script.py

karlpokus

{
  "data": [
      {
        "id":1, "name": "Mike", "human": true
      },
      {
        "id":2, "name": "Lucy", "human": false
      },
      {
        "id":3, "name": "Arnold", "human": true

karlpokus

// count unique values in pivot
http://stackoverflow.com/questions/11876238/simple-pivot-table-to-count-unique-values
Use "distinct antal" in dialog

karlpokus

function randomList(range, n) {
  //
  var checklist = [], out = [];
  // loop
  for (var i = 0; out.length < n; i++) {
    //
    var num = Math.floor((Math.random() * range));
    // if not in checklist
    if (checklist.indexOf(num) === -1) {
      //

karlpokus

function dataToJSON(data) {
  // out
  var out= [];
  // split
  var header = data[0],
      body = data.slice(1);
  // body LOOP
  for (var i = 0; i < body.length; i++) {
    //
    var o = {};

karlpokus

**VARIABLER**

# calc age
=Om Längd([Personnummer]) <= 13
  Så
    TillNummer(FormatDatum(AktuelltDatum(); "yyyy")) -
    TillNummer(Delstr([Personnummer]; 0; 4))
  Annars "-"

# relative date; today -n month

karlpokus

function dayDiff(f, s, abs){
  var f = new Date(f),
      s = new Date(s),
      oneDay = 24*60*60*1000;
  if (abs) {
    return Math.round(Math.abs((f.getTime() - s.getTime())/(oneDay)));
  } else {
    return Math.round((f.getTime() - s.getTime())/(oneDay));
  }
}

karlpokus

// completely mute
console.log = function() {};

// captured data in log
var log = [];
console.log = function() {
  log.push([].slice.call(arguments));
};

// fancy namespaced version. Demo -> http://codepen.io/KarlPokus/pen/rLwXQX/

karlpokus

// start
console.time('foo');

// do stuff

// end
console.timeEnd('foo');

// log output will be in ms -> foo: 268ms