Of course, it would be even better if you could easily tell which of the dozen JSON query tools is the best choice for the task at hand, or which you should code if you only want to ever use one of them.
In fact I'd love if someone would like to share their set of tried-and-true tools. Personally I mostly go with the POSIX tools, plus jq or gawk on occasion (but I have to read their docs every single time...).
One thing I could suggest for the XML list is xmllint. It can be really useful for converting xml to canonical format so you can then use diff to compare it.
E.g. something like
diff <(xmllint —c14 first.xml) <(xmllint —c14 second.xml)
I’d love to heat about more command line SOAP tools if anyone can recommend some.
tidy -xml -indent -wrap 0
tidy -xml -indent -wrap 0 -quiet
I personally prefer J to K in the APL family of languages. They also have a relatively cheap database, Jd . Individual licenses are $600. Still a bit too much for my data mangling needs. :)
There's also a per-core/minute pricing which might be useful.
But a lot of the use cases these other tools are good for are small tasks every now and then. I feel kdb+ is in a different category.
For example, removing nonconsecutive, duplicate lines from a file, such as a CSV file:
exec echo "k).Q.fs[l:0::\`:$1];l:?:l;\`:$1 0:l"|exec q >&2;
-1 distinct read0`:input
Sure, it is not as fast as many other formats, but on the other hand it integrates very well into Emacs an org-mode. I manage a large part of my different collections using a combination of both, and the Emacs integration means it is all less than 2 seconds away.
Edit: I’m looking for a command line tool that allows me to open an Excel file, make a few simple changes, and then save again as an Excel file.
It won’t help if you need to retain anything Excel specific, but I find it very useful to deal with any Excel files that come my way.
This sheet was formatted like:
You could whip up any command line tool you need with that.
That said, link to the manual in the bitbucket link not working.