Fix Trailing The 3.4 [MM2+3]

[G.I.]

Hi Trixmoto,

I finally want to change my trailing the's and a's back to what is normal, since I am using the trailing the since MM2.3

So a lot of stuff needs to be fixed now. I have taken a look at this script and it fixes a lot, but I have used a script from jiri I think ... normalize script. And this script also takes brackets and some other signs into consideration when making the trailing the.

This means that the songs for example will be called like:

Dark, the (Extensive Version)

Is it possible that you can change this in your script, that it's possible to fix these songs too, since I have a lot of songs that have this problem ...

Jiri used some kind of expression like this:

BracketExpr = " ~!@#$%^&*()_+\-={}|[\]\\:"";<>?,./"

to determine where the trailing , the should be placed.

Here I found the script I was using:

http://www.mediamonkey.com/forum/viewtopic.php?t=1524

[trixmoto]

I'll add this to my to do list.

[G.I.]

I keep you quite busy I think ... at least you won't get bored now haha!

[trixmoto]

I like to be busy!

[G.I.]

Hi Trixmoto,

have you found time to take a look at this?

Thanks in advance,

- G.I.

[trixmoto]

No sorry, not yet. It's on my list though.

[trixmoto]

New version (3.3) is now available to download from my website. It now allows for tracks of this format...

"Beatles, The (Extended)" -> "The Beatles (Extended)"

...to be fixed too, where the brackets can be (), [] or {}.

[trixmoto]

New version (3.4) is now available to download from my website. The SQL commands have been replaced with method calls so this script should now be MM3 compatible.

[Vyper]

Wow ..... updating scripts faster than I can install them.

[trixmoto]

Found myself some spare time to catch up on all the smaller changes that I've got listed to do!

[thefaceman]

OK, I am trying this script. I suspect it is user error. I have not modified it at all.

Errors are

(first error dialog)

Error#13 - Microsoft VBScript runtime error
Type mismatch: 'MainExec'
File: "M:\MediaMonkey\Scripts\FixTrailingThe.vbs", Line:1, Column:0

(Click OK, then second error dialog)

Error happend during script execution:
Type mismatch: 'MainExec'

FYI - My system is Vista. So I am guessing that is the problem.

-thanks
-thefaceman

[trixmoto]

Yeah, I've not seen this before. It could be a vista issue, looks like there's something wrong with your scripting host.

[G.I.]

I haven't had much time the last couple of weeks, but I will test this version (3.4) this week and I will let you know if it solved all my problems

(I can't do anything else then that, since I have been nagging all the time when you had time to fix this for me )

[G.I.]

Hi Trixmoto,

so far I have had no issues concerning the word "the", but I have also trailing a's ... as in for example an album with name: "A Nordic Poem" is now called "Nordic Poem, A".

Is it possible that you can change your script to also in include the two words: A en An

It's very cool by the way that you made that script so you can check what is will change! Thumbs up for that!

[trixmoto]

Open "FixTrailingThe.vbs" in a text editor and find the "The" list at the top of the file...

Code: Select all

Dim theList(3)		'this number must match the largest item number
theList(0) = "The"	'add more lines like this one for more words
theList(1) = "Der"	'the fewer words you have the faster it will process
theList(2) = "Die"
theList(3) = "Das"

Then amend the list, so your "A" list should be something like...

Code: Select all

Dim theList(2)		'this number must match the largest item number
theList(0) = "A"	'add more lines like this one for more words
theList(1) = "en"	'the fewer words you have the faster it will process
theList(2) = "An"