duplicates – Alexander Shyrokov's blog http://sjcomp.com/blog This's only my opinion, so keep it that way Mon, 21 Oct 2019 13:42:29 +0000 en-US hourly 1 https://wordpress.org/?v=4.9.16 Find duplicate files using OpenOffice.Calc http://sjcomp.com/blog/?p=334 Wed, 14 Oct 2009 02:35:18 +0000 http://sjcomp.com/blog/?p=334 I had a problem of having a set of directories with some files duplicated in some of the directories. The search for a software to remove duplicate files did not reveal any free utilities to accomplish this task. So I decided to use OpenOffice.Calc to do the job.

  • First I got the list of all the files: 
    dir /b/s >list.csv
  • Then, I opened list.csv in OpenOffice.Calc and used this formula to extract only the file name: 
    =RIGHT(A1;LEN(A1)-SEARCH("\\[^\\]*$";A1;1))
  • After that, I sorted the sheet by the file names and added a formula that detected duplicate file names: 
    =IF(B2=B1;"DUP";"")
  • Search for the string DUP (in values) quickly showed me where the duplicates are.

I know it was not as easy as running a specific program, but it was easier for me to do that than to find a free software.

]]>