New features in this version of InteractiveSieve are:
Load and Split
With Load and Split; you can load a CSV file and split rows that have a field that contains more than one value, separated by a separator character.
Take this example:
IP,Count,Methods 10.0.0.220,5,GET 10.0.0.45,13554,GET|POST 10.0.0.135,54302,GET|HEAD|POST
Fields in column Methods can have more than one value: GET, POST and/or HEAD. These values are separated by a pipe | character.
Simply loading this CSV file in InteractiveSieve gives this:
While using Load and Split with separator | for column 3 (Methods) gives this:
Ignore Comments
The Options dialog has now a field "Ignore comments":
This can be used to ignore each line that starts with the given line-comment character.
Take this CSV file for example:
#Produced 2024/06/01 IP,Count,Methods 10.0.0.220,5,GET 10.0.0.45,13554,GET|POST #Extra comment 10.0.0.135,54302,GET|HEAD|POST
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:
InteractiveSieve_V_0_9_3_0.zip (http)
MD5: 09FE2F374A789EDA8B9BC2A9DFE9E732
SHA256: A3AA9790772466953A3C37785C7F18E0B0201BC1CABEB8D12F674E0BDBF0FDA2
No comments:
Post a Comment