Skip to content

Instantly share code, notes, and snippets.

View borwick's full-sized avatar

John Borwick borwick

View GitHub Profile
@borwick
borwick / texlive snapshot as of 2022-06-03
Created June 4, 2022 03:12
naïve processing of texlive-archive
Created via:
pbpaste | perl -lne 'm|^([^.]+)| or die "No pkg name match for $_"; $PKG=$1; m|\b(\d{4}-\d{2}-\d{2})| or die "No date match for $_"; $DATE=$1; print "$PKG,$DATE" if $OLDPKG ne $PKG; $OLDPKG=$PKG' | pbcopy
Output:
12many,2019-02-28
2up,2020-05-10
a0poster,2020-03-04
a2ping,2019-02-28
@borwick
borwick / trolls.md
Last active June 8, 2020 03:35
Seattle protest Facebook trolls
@borwick
borwick / remove-msword-protections.sh
Created July 3, 2019 20:44
remove msword protections (e.g. to allow "compare documents")
#!/bin/bash
set -e
for i in ../folder-with-protected-docs/*.docx
do
FILENAME=${i##.*/}
FILENOEXT=${FILENAME%%.*}
ORIGZIPFILE="$FILENOEXT-orig.zip"
NEWZIPFILE="$FILENOEXT.zip"
echo $i
echo $FILENAME
@borwick
borwick / gist:6c49a59b8fa47040b184e4796bdb4195
Created June 27, 2019 17:31
Find who forwarded to whom in RT
SELECT Tickets.id, Users.EmailAddress, t.Data
FROM Transactions t, Tickets, Users
WHERE t.Created > DATE("2019-03-01") AND
t.ObjectId=Tickets.id AND
t.Type LIKE 'Forward%' AND
t.Creator = Users.id
ORDER BY Users.EmailAddress, t.Data, Tickets.id;

Keybase proof

I hereby claim:

  • I am borwick on github.
  • I am borwick (https://keybase.io/borwick) on keybase.
  • I have a public key whose fingerprint is 65C7 611E A32B 95E7 71D2 2BE1 08A1 9D14 958B 2044

To claim this, I am signing this object: