datacustodian

Perl Regular Expressions Manual

The SOURCE of knowledge for Perl regular expressions (REGEX):

https://perldoc.perl.org/perlre.html

PCRE is the most common REGEX flavor.

Why use Google and Stack Overflow, when you could consult the source?

datacustodian

GNU coreutils Manual

The SOURCE of knowledge for common Linux command line utilities:

https://www.gnu.org/software/coreutils/manual/coreutils.html

Why use Google and Stack Overflow, when you could consult the source?

datacustodian

Keybase proof

I hereby claim:

• I am datacustodian on github.
• I am datacustodian (https://keybase.io/datacustodian) on keybase.
• I have a public key ASB3eHNbL1E4mzPS7AHZzbyOoLOQWC8RczkrhkRTyiiuXAo

To claim this, I am signing this object:

datacustodian

VS Code Source Control Integration

Visual Studio Code is a popular and feature-rich IDE: https://code.visualstudio.com/

During the initial setup for source control (SCM) integration, especially in Mac OS X, you might encounter a "no source control providers" error.

Solution

After you verified that Git is installed on your system, use the command line to clone/check out a Git project.

datacustodian

Handling JSON Lines Format

JSON Lines text format, also called newline-delimited JSON, is a convenient format for storing structured data that may be processed one record at a time.

Files in JSON Lines format usually carry the extension .jsonl.

Official Site for JSON Lines Format: http://jsonlines.org/

jq Tool

datacustodian

Pretty Print JSON in Vim

https://pascalprecht.github.io/posts/pretty-print-json-in-vim/

Create a file name pretty_print_json.vim with the following content:

:%!python3 -m json.tool
:wq

If you only have Python 2 on your system, then remove the "3" after "python":

datacustodian

Convert Excel to CSV

https://wiki.openoffice.org/wiki/Documentation/DevGuide/Spreadsheets/Filter_Options

Note: Use --outdir option of soffice to specify a custom output directory.

TSV (9) UTF-8 (76)

find "`pwd`" -type f -iname "*.xls*" -exec soffice --headless --convert-to csv:"Text - txt - csv (StarCalc)":9,34,76,1,,0,false,true,true "{}" \;

datacustodian

Share AWS S3 Bucket With Another AWS Account

Example scenarios from the official AWS Documentation:

https://docs.aws.amazon.com/AmazonS3/latest/dev/example-walkthroughs-managing-access.html

datacustodian

Install avconv on Ubuntu

sudo apt install libav-tools

datacustodian

VeraCrypt Command Line

Create

veracrypt --text --create

Follow instructions to create a new VeraCrypt volume.

Mount