rmeekers

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

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

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

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 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;