Fun Song Game update

[dalesys]

Cleaned up text file of all postsfun Song 2.txt 368K

[BookstoreEscapee]

How do you compile all this?

This would actually be a fun thing to practice Access stuff on at work.
(Cuz lord knows the stuff I actually work with isn't any fun.)

[dalesys]

Usually I just drag across the text of the new posts, ^C, switch to my Word doc, Paste Special:Unformatted, and then clean out the extra stuff, and paste in the date for Yesterday/Today so an entry looks like this:

Raw capture:

#5024 Today, 08:49 AM
BookstoreEscapee BookstoreEscapee is online now
Sunny days...
Join Date: Dec 2006
Location: Central New Jersey
Posts: 5,553




--------------------------------------------------------------------------------

I'll Be That Girl - Barenaked Ladies
__________________
An apple a day keeps anyone away if you throw it hard enough. -Stephen Colbert, 10/15/2007
Don't believe everything you think.
No More Resolutions. Just change.


BookstoreEscapee
View Public Profile
Send a private message to BookstoreEscapee
Send email to BookstoreEscapee
Find all posts by BookstoreEscapee
Add BookstoreEscapee to Your Contacts

Editted to:

#5024 09-28-2010, 08:49 AM
BookstoreEscapee I'll Be That Girl - Barenaked Ladies

I'll then paste the new entries into another work file, put a tabs before the date, between AM/PM and Poster, and between Title and Artist, and then paste into coulmns B-F in an Excel spreadsheet.

Insert a column F in the new entries filled with 'x' and then sort the whole thing by Artist, Title, Post. Search by column for x in column F and change the 'x's to blank or abcd... if the Artist/Title has already been posted.

A few months ago I noticed that the post # was three more than the current post number, so last month I captured them all: Selected Quick Links: Edit Options and scrolled down to Thread Display Options and set Number of Posts to Show per Page to 40.

[BookstoreEscapee]

Wow.

You're, um, dedicated...

[El Pollo Guerrera]

Holy crow, Dalesys... that's a lot of work!

Thanks for doing it, too. I like looking back to see if a song I'm planning on listing has been used before.