Back then, I tested my hearing with Audacity, and I could hear a tone up to 14 kHz.
20 years later, I do the test again, and I can hear a tone up to 8 kHz.
It’s no surprise that my hearing declined over the years, that happens to everybody.
What did surprise me, or better said, what impressed me, is that a free and open-source tool like Audacity still exists after 20 years, and that I can just issue the exact same commands as 20 years ago!
When loaded in InteractiveSieve without “Ignore comments” character, the result is this:
And providing line-comment character # gives this:
Show
The Show command in the right-click menu for a row gives this dialog:
Sum
The Sum command in the right-click menu for a cell can be used to sum the numerical values of that column. There is no need to convert the text to numbers first.
Group
And finally, there’s the Group command in the right-click menu for a column.
This is a bit the opposite of Load and Split.
Take this CSV file for example:
Let’s say I want to group Methods by IP address. First I specify that column IP is the index:
Next I select column Methods to Group:
And then I specify the separator (~ in this example):
The original values can be restored with Restore from group:
This tool takes JSON output from tools like oledump, zipdump, base64dump, … via stdin and transforms the data produced by these tools. The transformation function (name Transform) has to be defined in a Python script provided via option -s.
This Transform function has 2 arguments: items and options. items is a list of dictionaries produced by the “feeding” tool , e.g., the tool whose JSON output is piped into this tool (oledump, …). Each dictionary has 3 keys: id, name and content.
The transformation function reads content from the items, and transforms it. The transformed data is the return value of the Transform function, and it can also be stored in the items list (modifying the values of the dictionaries, like the content value for example).
By default, this tool will output the transformed data (return value of Transform function) as binary data. With options -a, -A, -x, -X, -b, -B this output can be presented as ASCII dump, hex dump and base64 dump. Option -d is also present to explicitly request a binary dump.
If option –jsonoutput is used, then the return value of the Transform function is ignored, and in stead, the transformed items are output as JSON data. The –jsonouput option can not be combined with the above output format options.
Option -p (–parameter) is a string option that is passed on to the Transform function (via options argument). It is designed to be used by the developer of the Transform function as they see fit. For example, it can be used to tell the Transform function which item to select for transformation, in case there are several items.
When a file (attached to an email, or downloaded from the Internet) is saved to disk on a Windows system, Microsoft applications will mark this file as coming from the Internet. This is done with a ZoneIdentifier Alternate Data Stream (like a “mark-of-web”).
When a Microsoft Office application, like Word, opens a document with a ZoneIdentifier ADS, the document is opened in Protected View (e.g., sandboxed).
But when an Office document is stored inside an ISO file, and that ISO has a ZoneIdentifier ADS, then Word will not open the document in Protected View. That is something I observed 5 years ago.
But this has changed recently. When exactly, I don’t know (update: August 2021).
But when I open an Office document stored inside an ISO file marked with a ZoneIdentifier ADS, Office 2021 will open the document in protected view:
With an unpatched version of Office 2019, that I installed a year ago, that same file is not opened in Protected View:
After updating Office:
Word’s behavior has changed:
The file is now opened in Protected View.
If you want to test this yourself, you can use my ZoneIdentifier tool to easily settings a “mark-of-web” without having to download your test file from the Internet:
I did the same test with Office 2016, I updated an old version and: the document is not opened in Protected View.
I don’t know exactly when Microsoft Office 2019 was updated so that it would open documents in Protected View when they are inside an ISO file marked as originating from the Internet. But if you do know, please post a comment.
Update: this change happened in August 2021. See comments below. Thanks Philippe.