Category: Cheat sheets
-
SQL
VALUES lets you create an ad-hoc list. returns: num title 1 A 2 b 3 C It is nice to be able to make a VALUES list to pass in a list you want to filter by with a readable value and an ID for joining, then LEFT JOIN with the other tables to pull…
-
Regex
This regex matches image tags with a bunch of optional attributes in any order but a defined src: Useful tool for writing regex tests: https://regexr.com/3dvqn
-
Bash learnings
Bash things I always need to look up. Snippets If/then/else For loop Tools curl jq jq – command line JSON processor tr Transformations! Replacements, changing case, https://linuxhint.com/bash_tr_command/ Use | tr ‘\n’ ‘ ‘) to replace new lines with spaces. awk Awk is a command line text-processing tool. Use awk to replace a text with an…