mderazon

/*
 * script to export data in all sheets in the current spreadsheet as individual csv files
 * files will be named according to the name of the sheet
 * author: Michael Derazon
*/

function onOpen() {
  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var csvMenuEntries = [{name: "export as csv files", functionName: "saveAsCSV"}];
  ss.addMenu("csv", csvMenuEntries);

mderazon

var traverse = require('traverse');

// filter json obj by language
var filter_language = function(language, obj) {
  var result = traverse(obj).map(function(item) {
    if (this.key === language) {
      this.parent.update(item);
    }
  });
  return result;

mderazon

OIFS=$IFS;
IFS=",";

# fill in your details here
dbname=DBNAME
user=USERNAME
pass=PASSWORD
host=HOSTNAME:PORT

# first get all collections in the database

mderazon

if [[ "$1" == *.mp4 ]]
then
	/Users/me/bin/togif "$1"
fi
if [[ "$1" == *.png ]]
then
  /Users/me/bin/topic "$1"
fi

mderazon

youtube-dl -f 140 --ffmpeg-location /usr/local/bin/ffmpeg [list of youtube urls]
for f in *.m4a; do ffmpeg -i "$f" -acodec libmp3lame -ab 128k "${f%.m4a}.mp3"; done

mderazon

Validate URL in a Google Spreadsheet

Formula to check if URL in cell A1 in a Google Spreadsheet is up, using the W3C HTML Checker API

Formula

=IF(A1<>"",IF(ISERROR(FIND("non-document-error", INDEX(IMPORTDATA("https://validator.w3.org/nu/?out=json&doc=" & A1),0,2))),"✓","✗"),"")

Output

mderazon

# Use Dockerized infrastructure
sudo: false

# Use node_js environnement
language: node_js
node_js:
  - "6"

# Cache Gcloud SDK between commands
cache:

mderazon

import android.content.Context;
import android.graphics.drawable.Drawable;
import android.util.AttributeSet;
import android.view.MotionEvent;
import android.view.View;
import android.widget.AutoCompleteTextView;

/**
 * sub class of {@link android.widget.AutoCompleteTextView} that includes a clear (dismiss / close) button with
 * a OnClearListener to handle the event of clicking the button

mderazon

const req = require('superagent');
const writeFile = require('util').promisify(require('fs').writeFile);

const apiToken = process.env.API_TOKEN;
const baseUrl = 'https://dmarc.postmarkapp.com';

(async function() {
  const reports = [];

  // get a list of all reports by id and create time

mderazon

var link = 'https://example.com';
var textArea = document.createElement('textarea');

textArea.style.position = 'fixed';
textArea.style.top = 0;
textArea.style.left = 0;

textArea.style.width = '2em';
textArea.style.height = '2em';