rmeekers

#!/bin/bash
#run this first: chmod +x osx_install.sh

####
echo Install AppStore Apps first as we cannot do this automatically!
read -p "Press any key to continue... " -n1 -s
echo  '\n'

####
echo Install Homebrew, wget cask and a few other apps

rmeekers

javascript: (function() {
    var enc = encodeURIComponent,
        w = window,
        frames = w.frames,
        d = document,
        ms = w.getSelection ? w.getSelection() : (d.getSelection) ? d.getSelection() : (d.selection ? d.selection.createRange().text : 0),
        mu = w.location.href,
        mt = d.title,
        subjSpans = d.getElementsByClassName('hP'),
        i, url;

rmeekers

tell application "Google Chrome" to tell active tab of front window to set the URL to "
javascript: (function() {
    var enc = encodeURIComponent,
        w = window,
        frames = w.frames,
        d = document,
        ms = w.getSelection ? w.getSelection() : (d.getSelection) ? d.getSelection() : (d.selection ? d.selection.createRange().text : 0),
        mu = w.location.href,
        mt = d.title,
        subjSpans = d.getElementsByClassName('hP'),

rmeekers

javascript:
(function() { 
    var url = 'https://mail.google.com/mail/?view=cm&fs=1';
    var emailInput = prompt('E-mail address','');
    var subjectInput = prompt('Subject','');
    if (emailInput) {
        url += '&to=' + escape(emailInput);
    }
    if (subjectInput) {
        url += '&su=' + escape(subjectInput);

rmeekers

/*
 * Setttings
 */

// Google Drive Folder ID which contains the Excel files you want to convert
var driveFolderId = '';
// Folder name in which we should place the original files after conversion
var sourceFilesFolderName = 'Source Files';

rmeekers

/*
 * Datasource: public Google Spreadsheet with internet user data:
 * https://docs.google.com/spreadsheets/d/1uxPf0einHJxZqkTvXnFto0O8Q4Lxw9RBPKoBCV2idTE/edit
 *
 * In the example below, we expect one or more country codes (ISO 3166-1 alpha-2), separated by a pipe (|), in cell A2
*/
=
  SUM(
      QUERY(
            IMPORTRANGE("1uxPf0einHJxZqkTvXnFto0O8Q4Lxw9RBPKoBCV2idTE";"Data!B:C");

rmeekers

=TRIM(RIGHT(SUBSTITUTE(A2;"/";REPT(" ";100));99))

rmeekers

<tag>[\s\S]*?</tag>

rmeekers

/**
 * Set of functions to import CSV files into a Google Sheet
 * Imports CSV as text, freezes the first row, sets it bold and removes empty rows and columns.
 */

var settings = {
  CSVFolderID: '',
  singleFileID: '',
  CSVSeparator: ';'
}

rmeekers

This describes how you can convert an XML file to a simple HTML table. The table can then be copy/pasted into a Google Sheet for example for further manipulation.

Install Saxon

brew install saxon

Convert XML file to HTML

saxon -s:input.xml -xsl:stylesheet.xsl -o:result.html

Sample XSL