New features in this version of InteractiveSieve are:
Load and Split
![](https://blog.didierstevens.com/wp-content/uploads/2024/06/20240601-163441.png)
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:
![](https://blog.didierstevens.com/wp-content/uploads/2024/06/20240601-164041.png)
While using Load and Split with separator | for column 3 (Methods) gives this:
![](https://blog.didierstevens.com/wp-content/uploads/2024/06/20240601-164135-1.png)
![](https://blog.didierstevens.com/wp-content/uploads/2024/06/20240601-164148-1.png)
Ignore Comments
The Options dialog has now a field “Ignore comments”:
![](https://blog.didierstevens.com/wp-content/uploads/2024/06/20240601-164451-1.png)
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:
![](https://blog.didierstevens.com/wp-content/uploads/2024/06/20240601-165045-1.png)
And providing line-comment character # gives this:
![](https://blog.didierstevens.com/wp-content/uploads/2024/06/20240601-165133.png)
![](https://blog.didierstevens.com/wp-content/uploads/2024/06/20240601-165153.png)
Show
The Show command in the right-click menu for a row gives this dialog:
![](https://blog.didierstevens.com/wp-content/uploads/2024/06/20240601-165519.png)
![](https://blog.didierstevens.com/wp-content/uploads/2024/06/20240601-165604.png)
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.
![](https://blog.didierstevens.com/wp-content/uploads/2024/06/20240601-165831.png)
![](https://blog.didierstevens.com/wp-content/uploads/2024/06/20240601-165858.png)
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:
![](https://blog.didierstevens.com/wp-content/uploads/2024/06/20240601-170404.png)
Let’s say I want to group Methods by IP address. First I specify that column IP is the index:
![](https://blog.didierstevens.com/wp-content/uploads/2024/06/20240601-170516.png)
Next I select column Methods to Group:
![](https://blog.didierstevens.com/wp-content/uploads/2024/06/20240601-170731.png)
And then I specify the separator (~ in this example):
![](https://blog.didierstevens.com/wp-content/uploads/2024/06/20240601-170848.png)
![](https://blog.didierstevens.com/wp-content/uploads/2024/06/20240601-170909.png)
The original values can be restored with Restore from group:
![](https://blog.didierstevens.com/wp-content/uploads/2024/06/20240601-171129.png)
![](https://blog.didierstevens.com/wp-content/uploads/2024/06/20240601-171143.png)
MD5: 09FE2F374A789EDA8B9BC2A9DFE9E732
SHA256: A3AA9790772466953A3C37785C7F18E0B0201BC1CABEB8D12F674E0BDBF0FDA2