TreeSize Professional

Duplicate Search: Include Match Index in Export to identify groups

• Open
• Subscribe

---

Rashad

When exporting the result list from within Treesize File Search output to Excel file, a running index or match indicator would be helpful for Filtering purposes. Maybe it's available if I allowed for a Collapsible output, but I'm not using that functionality, but have Bold / Colored turned on. The issue is I want to filter these results for further analysis but in Excel you can't filter based on Text Format within a cell, so making these things Bold or Colorful is kind of useless.

Currently the only workaround is to create a new column, and enter an IF Formula to check if say for example, Path contains the text "[Multiple], if so, return 1, if not return 0 and then building an index off of the rows matching 1. This also helps you filter out the "Match Grouping Row" from your result, but I think we'd benefit from something being included an an official capacity.

I added some pictures, in my data, the actual grouped match index numbers were way different from a positon standpoint (408, 2209). I pulled just the "windows" matches out of the actual data for these examples, but when you're exporting 10's of thousands of rows filtering becomes a must.