• Welcome to DVD Collectors Online.
 

Reverse Alphabet Marathon - Discussion Thread

Started by RossRoy, October 23, 2007, 03:08:15 AM

Previous topic - Next topic

Tom

#15
For a help to determinate eligible titles:
Open a command prompt in the directory you have your collection.xml from Profiler. Enter the following command (replace ? with the appropriate letter):
findstr "?</Title>" Collection.xml
findstr "?</OriginalTitle>" Collection.xml

Another possibility. Import your collection in my CCViewer and use the following SQL query:
SELECT p.ProfileID, p.Title, p.ColNo, p.SortTitle, p.Originaltitle, p.OriginalSortTitle, p.Description FROM Profiles p WHERE p.Title LIKE '*$Title ends with$' OR p.OriginalTitle LIKE '*$Title ends with$';

Or do you guys know another way to determine this easily? Some of you have already compiled lists. How did you do it?



RossRoy

Quote from: TomGaines on October 24, 2007, 11:28:13 PM
Some of you have already compiled lists. How did you do it?

I used your CCViewer  ;D

richierich

Quote from: lyonsden5 on October 24, 2007, 11:24:20 PM
From what
Quote from: TomGaines on October 24, 2007, 11:14:47 PM
I have updated my list with titles I am planning to watch. Maybe (if there should be time left) I will watch a movie for "!" and for "?".

From what I just read 'somewhere else' Stephen King's It has a "!" at the end of it  :tease:

:hysterical:

Achim

Quote from: TomGaines on October 24, 2007, 11:28:13 PM
Or do you guys know another way to determine this easily? Some of you have already compiled lists. How did you do it?
Didn't know about this "findstr" stuff, so I simply used Excel (well, OpenOffice, to be precise). Exported to CSV, copied the Title to the spreadsheet and then used some IF and whatnot stuff to find the Titles for each letter. (I use such stuff a lot at work, so it seemed like a natural choice to me.

Najemikon

Ok, I have a query. I intend to watch a new DVD soon, and it may as well be part of this here marathon thingy. The DVD is Hostel Part II. Where the heck does it belong? Does it end in 'L' for Hostel, 'I' for the Roman Numeral II, or '2' because it isn't actually a letter 'I', it's a number. Argh! :stars:

richierich

Quote from: Najemikon on October 31, 2007, 01:13:29 AM
Ok, I have a query. I intend to watch a new DVD soon, and it may as well be part of this here marathon thingy. The DVD is Hostel Part II. Where the heck does it belong? Does it end in 'L' for Hostel, 'I' for the Roman Numeral II, or '2' because it isn't actually a letter 'I', it's a number. Argh! :stars:

use the credit block   :book:

(or whatever suits your marathon  :thumbup:  )

let us know what the film is like, as i haven't succombed to purchasing it yet

Achim

Quote from: Najemikon on October 31, 2007, 01:08:56 AM
:whistle: Quietly slips one in before the others arrive...  :tease:
:yellowcard: I saw that!!! :readthis:

Just kidding... As you may have noticed, I haven't started yet, despite having considered though. I have been busier than expected and actually just saw one (or was it two) DVD since completing the October marathon... I have stuff to do today and then will start the new marathon right away tomorrow. :training: Looking forward; I have nothing planned for the weekend and hope to get some letters scratched off the list then.

Quote from: richierich on October 31, 2007, 01:16:25 AM
(or whatever suits your marathon  :thumbup:  )
I'd have given that answer too. After all, it's all about this: :tv:

Quote
let us know what the film is like, as i haven't succombed to purchasing it yet
But don't spoil it, as I have it's currently in the mail on its way to me... I decided to go ahead after reading a favorable review at DVD Talk. Originally I was quite hesitant about this one.

richierich

I'm out of the starting blocks - should get a few under my belt by Sunday but then it will probably peak off

good viewing everyone  :thumbup:

RossRoy

And it's a start. Although I doubt I'll get one watched tonight, other interest getting in the way (hockey).

Good luck everyone, see you at the finish line (or anywhere along the way, if you don't get there)  ;D

Achim

I just finished the first one myself. Also hoping to get a good head start until Sunday (to compensate for the few days I'm unavailable towards the end of the month).

Good luck to all of you! :tv:

Tom

Just kicked off my marathon with the rather disappointing Twilight Zone movie.



RossRoy

Well, my marathon is officially started.

I took an easy start though: Rocky IV, which I had seen before (even though I forgot to mark it as such in the listing), and is probably my favorite of them all.

So the ice is broken, we'll see how deep I sink ;)

lyonsden5

Spiderman 3 got me started tonight. It's nothing compared Spiderman 1 that's for sure.

Kathy

I am still filling out my list but I decided to start with Funny Girl. I had seen this when it first came out...aaggghhhh 40 years ago! I thought it was great then and it has stood the test of time. Of course I love Barbra Streisand and then there's Omar Sharif. :drooling:

lyonsden5

Question - does Spiderman 3 count as a number? I thought someone else brought it dealing with sequels but I can't find it.