I opened it, 14,000 lines/files. I noticed the TTH was listed as well as the filename corresponding to that hash, file size, date/time acquired, client, drive it is stored on, and maybe 5 other items.
Now at the top of the file is the coding info, it is a valid .xml file. At the bottom, same thing.
In a text editor, I deleted the top and bottom junk. I now have a complete listing of all my files. But it is an XML file, and Open Office is not properly reading it as a spreadsheet.
What I do have for each file looks like this:
Code: Select all
<File Name="\\DESKTOP\hdc1\DC++\Software\pcANYWHERE v1.02 for Windows CE.exe" Size="1296709" TimeStamp="1050660952"><Hash Type="TTH" Index="7824896" LeafSize="65536" Root="HT6DO5C2AFRVY7R6F6GGLTRG5M7NDJUSSLCLIHY"/></File>
Now, all we need is someone who can find a way to put that into a spreadsheet accurately enough that all the areas are seperated by columns, right?
It would need to be seperated with a few different delimiters, Specifically like this:
Code: Select all
| " | " | = | | = | > | = | | = | | = | | " | " |Then colums could be moved, or deleted. Simply insert a column here and there around the file name and TTH, so that when merged together they would all be links.
This would work right??
Please somebody tell me they know how to use a spreadsheet better than me. I can't get the text to columns thing to work for me.