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.
brew install saxon
saxon -s:input.xml -xsl:stylesheet.xsl -o:result.html
Rutger Meekers rmeekers
rmeekers
/ Send Gmail email to Omnifocus.bookmarklet.js
Last active
November 23, 2016 16:04
Bookmarklet to send Gmail email to Omnifocus. Email subject will become the action title. A link to the email will be added to the action notes. If you've selected some text, it will be added to the notes as well.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 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
/ Send Gmail email to Omnifocus.applescript
Created
November 23, 2016 16:05
Applescript to send Gmail email to Omnifocus. Email subject will become the action title. A link to the email will be added to the action notes. If you've selected some text, it will be added to the notes as well.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 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'), |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 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
/ importNumberOfInternetUsersPerCountry.gs
Created
June 6, 2018 09:28
Formula to import the number of internet users for a given country
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| /* | |
| * 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
/ Extract filename from URL in Google Sheets
Created
April 4, 2019 17:29
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| =TRIM(RIGHT(SUBSTITUTE(A2;"/";REPT(" ";100));99)) |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| <tag>[\s\S]*?</tag> |
rmeekers
/ Import CSV in Google Sheets.gs
Last active
September 24, 2019 09:31
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| /** | |
| * 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
/ convertXMLtoHtml.md
Last active
September 24, 2019 12:39
rmeekers
/ difference between straight and curly quotes.md
Created
March 13, 2020 11:13
What's the difference between straight and curly quotes?
Straight quotes are the generic vertical quotation marks which are inserted via the quotes button on a keyboard. There are two variants:
- 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:
- Single quotes: the opening single quote (‘) and the closing single quote (’)
- Double quotes: the opening double quote (“) and the closing double quote (”).
rmeekers
/ vlookup_in_multiple_columns.md
Last active
April 24, 2020 07:13
Google Sheet formula to do a vlookup in multiple columns
Assumptions:
- 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)))))
OlderNewer