Instantly share code, notes, and snippets.

  1. Assumes a text field called Email
  2. Create a Calculation field
  3. Use this formula to calculate a text result:
Middle ( 
Email ; 
Position ( Email ; "@" ; 1 ; 1 ) + 1 ; 
Length (Email) - Position ( Email ; "@" ; 1 ; 1 ) + 1
# did: Search the command history for what you did before
did() {
history | grep $@ |grep -Ev "grep" | grep -Ev "did" | sed 's/\(.\{7\}\)//'| sort -u
View Platformio-Dockerfile
FROM resin/rpi-raspbian
RUN apt-get update && apt-get -y upgrade
RUN apt-get install -y curl python
RUN python -c "$(curl -fsSL"

On device:

[root@runeaudio ~]# telnet localhost 6602

Connected to localhost.
Escape character is '^]'.
spop 0.0.1
arp -a | grep b8:27:eb | grep -Eo '[0-9]{1,3}\.[0-9]{1,3}\.[0-9]{1,3}\.[0-9]{1,3}'

Keybase proof

I hereby claim:

  • I am andrewpmiller on github.
  • I am andrewpmiller ( on keybase.
  • I have a public key whose fingerprint is CD51 AC3B 2FF6 1E99 82DD C7D3 2FC3 2B74 3DE6 A9F2

To claim this, I am signing this object:


Google analytics include

<script type="text/javascript">
  var _gaq = _gaq || [];
  _gaq.push(['_setAccount', 'UA-0000000-00']);
  (function() {
    var ga = document.createElement('script'); ga.type = 'text/javascript'; ga.async = true;

Edit your crontab with nano

Because vim ruins my day every time...

export VISUAL=nano; crontab -e


Homebrew Permissions Fix

Everyone hates antivirus software – except IT departments.

Sophos does a particularly annoying thing on my work MacBook... some process (I think it's called "Sweep") constantly changes the permissions on /usr/local/bin so that I can't update or install Homebrew packages.

This unlocks things temporarily:

sudo chown -R $(whoami) /usr/local/bin