- https://github.com/johnkerl/miller
- https://csvkit.readthedocs.io – Miller is quite similar to csvkit
Blog
-
“Miller” is like awk, sed, cut, join, and sort for name-indexed data such as CSV, TSV, and tabular JSON
-
Tom HaCohen’s home page and blog
- https://stosb.com
- https://stosb.com/tag/explaining-configs/ – “Explaining My Configs: …” – ssh client, sshd_config, OpenVPN, nftables
-
“pdftohtml -xml” – only the poppler suite supports “-xml”
- https://forum.xpdfreader.com/viewtopic.php?f=3&t=41211
- only the poppler toolset (the xpdf-related toolset) has “pdftohtml -xml“
- https://en.wikipedia.org/wiki/Poppler_(software)
- https://poppler.freedesktop.org
- https://anongit.freedesktop.org/git/poppler/poppler.git
One of my most favourite tools.
I have been using it for years now – on a daily basis. (I came across it in my local Ruby user group many years ago.)
Of course it only works on PDF with text.
Luckily enough there are tools resp. services, that “OCR” your “image PDF”, just in case your PDF file does not include the text it shows as text.
I am editing the XML result in Emacs with nXML mode, and I developed a RELAX-NG grammar for context sensitive editing of such XML files.
I am annotating these XML files using specific XML comments.
For PDF files from several providers I created scripts for automated annotation. (Best case: find lvalue and rvalue together. Most of the time I find at least lvalue.)
I created scripts to extract the details from those annotations. And they create text, that resembles by (personal home-made / home-maintained) bank statements – so I can “reconcile” them.I am processing every bill PDF like that.
I am processing every contract PDF like that. I guess you understand, how much better it is to read and annotate a text file in place instead of keeping notes outside the source. Yes, that’s of course like inline documentation within programming language source files.
Just in case anybody reads this and finds it useful: Of course I am able and most willing to provide far more details.
-
the Bitwarden command-line tool
- https://bitwarden.com/help/article/cli/
- https://stedolan.github.io/jq/ – “bw” (the CLI utility) works well with jq
-
csvkit: in2csv: the Excel killer
- https://csvkit.readthedocs.io
- https://csvkit.readthedocs.io/en/latest/tutorial/1_getting_started.html#in2csv-the-excel-killer
- in2csv can certainly deal with .xls and .xlsx Excel files
- for .xlsx files it can:
- list the names of all sheet names
- parameterised to extract the specified sheet