I'd like to know if it's possible for Applescript to do the following:
Take a text file with 600+ URLs and compare it to another text file with 100,000+ URLs and set out as a result any URL from the first small list that is NOT included in the second larger list?
If it is possible to do this, is there anyone out there willing to create such a script for a modest fee?
Tony,
Thanks again, but this didn't do the trick either. The diff.txt file that it produced contained all of the URLs in File1, instead of just the single one that it should have called out.
If you want to continue to play around with this, I put the test files in my dropbox, as I noted to Frank: https://www.dropbox.com/sh/90b8vzyuoaok3lp/zbNVQY9pmv
Chris,
twtwtw's Applescript works as long as the first file is a simple list of URL's as you put into Dropbox.
If the first file will have text intermingled then adding a grep to the script get the URLs out before running twtwtw's script is easy to do.
Give his script a shot and report back. I tried it on the files you put in Dropbox and it seemed to do the trick.
regards
Tony,
I think trying to do this with the grep is, to me anyway, getting a tad complicated. As long as the URLs were one per line that seemed like a good option but now I think the Applescript posted by twtwtw is the clear favorite.
regards
cdworin wrote:
The diff.txt file that it produced contained all of the URLs in File1, instead of just the single one that it should have called out.
If you want to continue to play around with this, I put the test files in my dropbox, as I noted to Frank
I saw that and tested it on File1.txt (selected 1st) and File2.txt (selected 2nd), diff.txt then had one item:
http://xxx.travelnow.com/hotels/1000000/10000/4100/4054/4054_1333_b.jpg
Yes, while it would take a little longer to process large files, I agee.
TWTW, Frank and Tony.
I ran TWTW's script with my abbreviated test files and it worked just fine.
I then created a smaller version of File1, but ran it against the full 800MB version of File2. It ran for awhile, but unfortunately eventually stopped with the following error message: "
error "An error of type -116 has occurred." number -116"
I'm guessing that it ran into some URL in File2 that it couldn't process. I searched that file to see if any of the photo URLs were png files, but none of them were.
Any easy fix for error 116?
Hiroto,
Your script worked very well. Thank you so much!!!
Best,
Chris
Looks like 116 is a Memory Manager error: https://discussions.apple.com/thread/2587470?start=0&tstart=0
Possibly due the file size. Can you reduce the size of the 800mg file to test if this is the problem?
Frank,
Hiroto's applescript worked perfectly for my needs (on test files both with and without hotel names), and was pretty fast, to boot. So, I think we have our solution. Thanks so much for all your work on this. I really appreciate it.
Best,
Chris
TWTW,
Your script was great. Thanks! But it still needed a bit of tweaking because I was getting an error message when I ran it against my large data file. Meanwhile, I tested Hiroto's applescript and it worked perfectly for my needs (on test files both with and without hotel names), and was pretty fast, to boot. So, I think we have our solution. Thanks so much for all your work on this. I really appreciate it.
Best,
Chris
No need to check this. Hiroto's script worked w/o generating any errors.
cdworin wrote:
No need to check this. Hiroto's script worked w/o generating any errors.
Great! Looks like Perl (wrapped in an Applescript) was the correct tool for this (I was using a hammer with grep, sort and comm 🙂)
Not all my replies seem to make it to this thread. Here goes a final one:
Hiroto's script worked just as I needed, against the full 800MB file, both with and without hotel names in the smaller file. So, I think that's my answer. Thank you so much, Hiroto, for the help!
Frank, Tony and TWTWTW, you guys were awesome and I really appreciate all the time and effort you put into this. One thing I learned from all this (besides what a great resource the Apple communities are), is how many different ways via scripting there are to tackle the same problem. A real eye-opener!
Best,
Chris
Frank and TWTWTW,
I wanted to give you guys a "This helped me" shout out, but for some reason, all those links disappeared from the thread. I think clicking on "This solved it" must have turned off all those other links. Sorry about that. You really did help me. Thanks!
Ok, as they say in the moving picture business "That's a wrap'.
regards
Can applescript search one file for non-matches in another file?
