Help with TextWrangler

[Salvacion]

Hey,

First, I hope this is in the right section and if not I apologize. Here's my situation:

I have a list of names that I want to crosscheck with a bigger list of names that also contains addresses. I'm using textwrangler for the big database and I know that you can do a pretty extensive search, but I don't want to have to open the find window and type every name manual so, I want to know if there is a way that I can automate searching for the names across two different files. If anyone has a link to a tutorial explaining how to do this or something similar I would greatly appreciate it as this would save me about half a week of menial work.

Thanks in advance

 

[iShater]

So file A contains single rows with names. File B contains single rows with names and addressed on the same line? And you want to get the full line from file B that matches the names in file A?

 

[Salvacion]

both files contain names and addresses on a single line, however, one contains older addresses. I want to check the names in file A against the records in file B and see if the addresses match or if there is a more up to date address in file B. Also, file A is comma separated.

 

[HiRez]

both files contain names and addresses on a single line, however, one contains older addresses. I want to check the names in file A against the records in file B and see if the addresses match or if there is a more up to date address in file B. Also, file A is comma separated.

One thing that might make this really easy is the app FileMerge, which highlights differences between two different files. This would only work if the addresses in the two files are in the same order (although pre-sorting the files with TextWrangler might help). I believe you need the developer tools installed to have this app though, which you can do for free: developer.apple.com. You can also use the command-line "diff" (not sure if that's installed with the dev tools or comes with the OS). You can also use Text-Wrangler search/replace to normalize the formats first (comma-separated, etc.).

 

[Salvacion]

I'm downloading Xcode now I just hope there aren't too many differences between the two files. Thanks for the tip

update :Apparently the files are too big for FileMerge, every time I try to compare both of them the application stops responding. Is there another application or method that could solve the problem? I really don't want to type 2K+ names one at a time

 

[Salvacion]

So file A contains single rows with names. File B contains single rows with names and addressed on the same line? And you want to get the full line from file B that matches the names in file A?

Actually, I was just given the original excel file for the shorter file, which means I can export a csv file with only the names.

 

[David Sudweeks]

TextWrangler keyboard shortcut that opens Opera browser

Quick question: I once by accident performed some keyboard shortcut in TextWrangler that launched what I was working on in an Opera browser window. (I did not know that I had installed Opera / tried unsuccessfully to locate Opera in the Applications folder.) So my question is secondarily 'Does TextWrangler install Opera?' and primarily 'How do I do it again?' I forgot whatever keyboard shortcut got me there.

It's version 3.1 (2640) of Tue, 19 Jan 2010
standard install, no add-ons.

Answers I'm not looking for: How to install Opera.

 

[angelwatt]

So my question is secondarily 'Does TextWrangler install Opera?' and primarily 'How do I do it again?'

No it does not. Opera is installed by some Adobe applications though and is often the culprit.

Here's a page for creating a script to open the page in a browser. I don't know of a feature built-in TextWrangler for doing it, but BBEdit (it's big brother) does have it. Maybe something else caused the file to open up rather than it being TextWrangler.

 

[David Sudweeks]

Thanks.