gnorris Posted June 16, 2011 Share Posted June 16, 2011 The title's fairly self explanatory. I want to compare two list and create a third list with items not contained in both. This is actually part of my Backup project, after using Super Copier 2 to copy the contents of my internal drives (one HDD two partitions) I need to find what items are on the backup drive and not the original (what files I deleted from my internal drive). I already have a method of making the list (though it does have a few extra entries that I've not been able to erase and I still need to modify the first list) what I'm looking for here is a way of comparing them. Link to comment Share on other sites More sharing options...
JohnOne Posted June 16, 2011 Share Posted June 16, 2011 In order for someone to give you advice, I suggest you make available the method you "already have a method of making the list". People will know what they are dealing with then (a text file, and sql database, array, etc... AutoIt Absolute Beginners Require a serial Pause Script Video Tutorials by Morthawt ipify Monkey's are, like, natures humans. Link to comment Share on other sites More sharing options...
jchd Posted June 16, 2011 Share Posted June 16, 2011 Read solutions in This wonderful site allows debugging and testing regular expressions (many flavors available). An absolute must have in your bookmarks.Another excellent RegExp tutorial. Don't forget downloading your copy of up-to-date pcretest.exe and pcregrep.exe hereRegExp tutorial: enough to get startedPCRE v8.33 regexp documentation latest available release and currently implemented in AutoIt beta. SQLitespeed is another feature-rich premier SQLite manager (includes import/export). Well worth a try.SQLite Expert (freeware Personal Edition or payware Pro version) is a very useful SQLite database manager.An excellent eBook covering almost every aspect of SQLite3: a must-read for anyone doing serious work.SQL tutorial (covers "generic" SQL, but most of it applies to SQLite as well)A work-in-progress SQLite3 tutorial. Don't miss other LxyzTHW pages!SQLite official website with full documentation (may be newer than the SQLite library that comes standard with AutoIt) Link to comment Share on other sites More sharing options...
gnorris Posted June 18, 2011 Author Share Posted June 18, 2011 @JohnOne My Apologies I thought I mentioned that part. I'm using text files which I get via Dir Commands. The files are a list of files by directory. I use a still pending method (I have a method but I'd like a better one) to Search and replace the references for the C file (dir of C:\) to reflect their backup locations on my External. With this accomplished I need to compare what are essentially a list of files that should be on the drive and a list of files that are on the drive. Since I do the copy Op first the non-duplicate files are those I need to erase. @jchd Thanks for the link I'm thinking of using KaFu's but I've not much experience using extra libraries (libraries you have to explicitly call) in AutoIt so I'll have to do some research. Is file.au3 a built in library or is it available somewhere else? It looks like your script would involve SQlite which might be installed somewhere on my system but I really don't use it myself (I use some self compiling programs for Homebrew and such and those might have something). Thanks for the help. Link to comment Share on other sites More sharing options...
jchd Posted June 18, 2011 Share Posted June 18, 2011 AFAICT all the example code given in this thread are self-contained and should run out of the box. All include files are native, including SQLite and thus require no external tool nor any installation. Of course you'll have to change pathes for them to run on your system. Now while the goals are similar, the result they're going to give is not directly what you want. You want the orphan list. This can't be produced by the Scripting Dictionary version, but can be by the SQLite version with a little modification in the handling of data. This wonderful site allows debugging and testing regular expressions (many flavors available). An absolute must have in your bookmarks.Another excellent RegExp tutorial. Don't forget downloading your copy of up-to-date pcretest.exe and pcregrep.exe hereRegExp tutorial: enough to get startedPCRE v8.33 regexp documentation latest available release and currently implemented in AutoIt beta. SQLitespeed is another feature-rich premier SQLite manager (includes import/export). Well worth a try.SQLite Expert (freeware Personal Edition or payware Pro version) is a very useful SQLite database manager.An excellent eBook covering almost every aspect of SQLite3: a must-read for anyone doing serious work.SQL tutorial (covers "generic" SQL, but most of it applies to SQLite as well)A work-in-progress SQLite3 tutorial. Don't miss other LxyzTHW pages!SQLite official website with full documentation (may be newer than the SQLite library that comes standard with AutoIt) Link to comment Share on other sites More sharing options...
Zedna Posted June 18, 2011 Share Posted June 18, 2011 I recommend using SQLite, here are links to some my examples: Resources UDF ResourcesEx UDF AutoIt Forum Search Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now