- Press CTRL-H ( ⌥⌘F on Mac ).
- Press ALT-R ( ⌥⌘R on Mac ).
- Type
_([a-zA-Z])
. - Press TAB and type
$1
. - Press ALT-ENTER ( ⌥ENTER on Mac ).
- Press F1 and type
upper
, then press ENTER. - Press CTRL-ALT-ENTER ( ⌥ENTER on Mac ).
#!/bin/bash | |
# | |
# | |
# Author: Duncan Isaksen-Loxton | |
# Web: sixfive.com.au | |
# | |
# PREREQUISITES |
import socket | |
import asyncio | |
import websockets | |
import time | |
import logging | |
import argparse | |
import threading | |
import sys | |
[ | |
{ | |
"constant": true, | |
"inputs": [], | |
"name": "name", | |
"outputs": [ | |
{ | |
"name": "", | |
"type": "string" | |
} |
Disclaimer: If you believe that Typescript is a conspiracy by Microsoft to turn Javascript into C# and you believe in the religion of monkey-patching objects, then please do not proceed further. This article will burn your soul if you read it
Ever since I have started using Typescript, I cannot imagine writing large projects in plain JS anymore. My relationship to Typescript is best explained by this very nicely articulated piece by Tom Dale
While Typescript can make working with frontend frameworks like Angular and Vue a whole new revelation, using it on backend projects can have equally pleasing results. What I like about Typescript is the strictness can be turned a few notches up or down based on your requirements. And as you keep turning the strictness up by notches, you start seeing Typescripting starting to blo
<?php | |
//increase max execution time of this script to 150 min: | |
ini_set('max_execution_time', 9000); | |
//increase Allowed Memory Size of this script: | |
ini_set('memory_limit','960M'); | |
// Copies woocommerce orders and users over from source to target. | |
// I use this on my local machine - loading both db's up there side by side | |
// could easily adjust the connect strings to connect elsewhere if needed. |
/**************************** | |
* Add a Placement Exclusion When an Automatic Placement Contains the Text ... | |
* Version 1.0 | |
* | |
* Created By: Frederick Vallaeys | |
* for FreeAdWordsScripts.com | |
* at the request of an Optmyzr.com subscriber | |
****************************/ | |
function main() { |
onEdit(e)
which is used for the Edit event on Spreadsheet has the old value as e.oldValue
. The specifications for this are as follows.
- When an user edited a single "A1" cell,
e
ofonEdit(e)
showshoge
fore.oldValue
andfuga
fore.value
. - When an user edited the "A1:A2" multiple cells,
e.oldValue
ande.value
ofonEdit(e)
are not shown anything. - When an user copied and pasted from other cell,
e.oldValue
ande.value
ofonEdit(e)
are not shown anything.
This sample script was created to retrieve both the edited values and the old values for the range of edited cells. This is the modified e.oldValue
.
/* | |
* script to export data of the named sheet as an individual csv files | |
* sheet downloaded to Google Drive and then downloaded as a CSV file | |
* file named according to the name of the sheet | |
* original author: Michael Derazon (https://gist.github.com/mderazon/9655893) | |
*/ | |
function onOpen() { | |
var ss = SpreadsheetApp.getActiveSpreadsheet(); | |
var csvMenuEntries = [{name: "Download Primary Time File", functionName: "saveAsCSV"}]; |
This script for Google Spreadsheets allows you to generate slugs for your data such as might be used for creating unique urls.
Use it like this!
# | A | B | C |
---|---|---|---|
1 | a | b | slug |
2 | foo | baz bing | =slugify(A2:B4) |
3 | bar | BAZ | |
4 | FOO | baz-bing |