Sign in to follow this  
Followers 0
gnorris

Massive List Comparison

6 posts in this topic

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.

Share this post


Link to post
Share on other sites



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.

Share this post


Link to post
Share on other sites

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 here
RegExp tutorial: enough to get started
PCRE 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)

Share this post


Link to post
Share on other sites

@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.

Share this post


Link to post
Share on other sites

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 here
RegExp tutorial: enough to get started
PCRE 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)

Share this post


Link to post
Share on other sites

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 account

Sign in

Already have an account? Sign in here.


Sign In Now
Sign in to follow this  
Followers 0