Page 21 of 22

Re: Case & Leading Zero Fixer 1.4.2 (2008-04-15)

Posted: Sun May 27, 2012 8:48 am
by mlr
Vyper,

Thanks, tried it but it then changes the Title "the" to "The", not what I need, I want it to look like this:
Diana Ross & The Supremes - Stop! In the Name of Love

Re: Case & Leading Zero Fixer 1.4.2 (2008-04-15)

Posted: Mon May 28, 2012 6:04 am
by Vyper
Oh! Sorry, didn't realize that. That may be a toughie.

Re: Case & Leading Zero Fixer 1.4.2 (2008-04-15)

Posted: Thu May 31, 2012 3:33 am
by mlr
Is there a way I can pin this to a toolbar?

Re: Case & Leading Zero Fixer 1.4.2 (2008-04-15)

Posted: Thu May 31, 2012 7:19 am
by Vyper
Not sure what you mean by that but how about this:

In the options, use the dropdown box next to Artist and change it to Upper Case. Leave the title at Script Case.

Re: Case & Leading Zero Fixer 1.4.2 (2008-04-15)

Posted: Thu May 31, 2012 7:45 am
by mlr
Sorry for the vagueness…

Currently the only place I can find this script to run is on the selected the track(s) Right Click Menu just above Properties or an assigned Hot-Key…

I created my own Shortcut Toolbar; I want to add this to it.

Thanks

PS! Does anyone know if we can request some additional functions (wish list) for this script?

Re: Case & Leading Zero Fixer 1.4.2 (2008-04-15)

Posted: Fri Jun 01, 2012 7:14 am
by Vyper
Did my suggestion do what you wanted regarding the word 'the'?

Re: Case & Leading Zero Fixer 1.4.2 (2008-04-15)

Posted: Mon Jun 04, 2012 8:49 am
by mlr
Vyper wrote:Did my suggestion do what you wanted regarding the word 'the'?
No, it changes the Artist all to Uppercase & Title to Script Case.

Doesn't look like I'll get around this as I have a couple of other bespoke funnies say if a title is The Queen and the Soldier (Live), I want it as: Queen and the Soldier, The (Live)

Re: Case & Leading Zero Fixer 1.4.2 (2008-04-15)

Posted: Sat Nov 24, 2012 8:15 am
by tommycrock
Just wanted to show some SQL for anyone with problems removing leading zeros from tracks 010 to 099 etc. Using the SQL-Viewer script, execute:
UPDATE Songs SET TrackNumber=CAST(TrackNumber AS Integer) Where TrackNumber Like "0%"

Re: Case & Leading Zero Fixer 1.4.2 (2008-04-15)

Posted: Sat Nov 24, 2012 9:02 am
by tommycrock
mlr wrote:Is there a way to mark “The” not to change to “the” in the following?
Adam and The Ants, Adele & The Raconteurs, Diana Ross & The Supremes…
Using the SQL Viewer addin, you could try:

Code: Select all

UPDATE Songs SET Artist= Replace(Artist, ' the ', ' The ') WHERE Artist glob "* & the *" OR Artist glob "* and the *"
This will update other "the"s to The in any artist with "& the" or "and the" so if someone had the name "For the Laughs and the Giraffes" it would become "For The Laughs and The Giraffes" but there can't be too many examples like that. (Treat with caution - I've not tried this!)

Re: Case & Leading Zero Fixer 1.4.2 (2008-04-15)

Posted: Sun Mar 24, 2013 1:49 pm
by DocWeini
Is this script still under development?

Re: Case & Leading Zero Fixer 1.4.2 (2008-04-15)

Posted: Sat Dec 07, 2013 10:35 pm
by adamg
2 questions:

1. I cannot figure out how to add artists such as: 3OH!3, B.o.B., a-ha, t.A.T.u and Bachman-Turner to the Forced-Case Word list?
I assume the "-" and the "." and the "!" symbols are the problem. How can i add artists with these symbols to the "Little Words" list or the "Forced-Case Word" list? Or can I?

2. where is the user-defined list of words i add to the forced-case and little words database so i can edit it manually?
i would ultimately like to be able to have a list stored somewhere outside of mediamonkey so when i uninstall and reinstall MM i will not have to reinsert EVERY "forced-case" or "little word" into the script, that would be a big pain (reinserting a few hundred words.) I have looked in the mediamonkey.ini, casemodify.vbs, and browsed the MM.DB looking for the info to no avail.

Re: Case & Leading Zero Fixer 1.4.2 (2008-04-15)

Posted: Sat May 30, 2015 5:00 pm
by sn0skier
Seems to be a problem where if there is a 3 digit track number, and you have the option set to remove all leading zeros, the leading zero on tracks with track numbers >= 10 do not lose there leading zero (though tracks 1-9 do lose both leading zeros, which is good) [e.g "004" changes to "4" which is good, but "012" stays "012", which is not so good.]

Re: Case & Leading Zero Fixer 1.4.2 (2008-04-15)

Posted: Mon Jul 25, 2016 12:12 pm
by Tursiops47
I have C&LZF 1.4.2 extension installed in MM 4.1.13.1801. When I run it corrects Title and Filename OK but changes track numbers 01-09 to single digit.
(1) How do I navigate to configuration screen to add zero to single digit track numbers?
(2) Can I use this script to move "The" and "A" from front of Title to end of title? eg Girl from Ipanema, The

Re: Case & Leading Zero Fixer 1.4.2 (2008-04-15)

Posted: Mon Jul 25, 2016 12:34 pm
by gpzbc
Hi!
1) You can access the C&LZF settings from the Tools --> Options --> Case & Leading Zero Fixer menu.
2) You can use MM's Auto-Organize Files tool to accomplish what you describe. Check out the $MovePrefix mask.

There should be a ton of info in the forums on these things, but post back if not. Good luck!

Re: Case & Leading Zero Fixer 1.4.2 (2008-04-15)

Posted: Tue Aug 16, 2016 1:19 pm
by Tursiops47
Thank you gpzbc. That was so easy ... once I followed the path!