Skip to content

Instantly share code, notes, and snippets.

rmeekers / node_red.json
Last active May 16, 2023 09:01
Node Red flow to monitor Eeve / Toadi to Home Assistant via MQTT (including auto discovery) -
View node_red.json
"id": "76106b40e1ce3c2f",
"type": "tab",
"label": "Toadi to MQTT",
"disabled": false,
"info": "",
"env": []
View Regex to split street into street, number and box
rmeekers /
Last active April 24, 2020 07:13
Google Sheet formula to do a vlookup in multiple columns


  • value to look for is in cell C2
  • array to search in: 'email domains'!A:Y
  • value to retrieve is in column no 26 (Z)
=ArrayFormula(if(countif('email domains'!A:Y;C2)=0;"";index('email domains'!A:Z;sum(if('email domains'!A:Y=C2;row('email domains'!A:Y))); sum(if('email domains'!A:Y=C2;26)))))
rmeekers / difference between straight and curly
Created March 13, 2020 11:13
What's the difference between straight and curly quotes?
View difference between straight and curly

Straight quotes are the generic vertical quotation marks which are inserted via the quotes button on a keyboard. There are two variants:

  1. the straight single quote (') and 2 .the straight double quote (").

Curly quotes are the quotation marks used in good typography. There are two sets of curly quote characters:

  1. Single quotes: the opening single quote (‘) and the closing single quote (’)
  2. Double quotes: the opening double quote (“) and the closing double quote (”).

How to use these quotes in a text editor?


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

View Import CSV in Google
* 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 /
Created June 6, 2018 09:28
Formula to import the number of internet users for a given country
* Datasource: public Google Spreadsheet with internet user data:
* In the example below, we expect one or more country codes (ISO 3166-1 alpha-2), separated by a pipe (|), in cell A2
rmeekers /
Created December 11, 2017 08:46
Bulk Convert XLSX Files in Google Drive To Google Sheet
* 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';