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

[tooone7]

Or perhaps show the SQL you use to do the leading zero checking

With a bit of help I'd be happy to try modifying this script.

Hi Tommycrock,
I found a temporary solution if you're interested.

Get the SQLViewerScript created by Bex.

Go to Tools->Scripts->SqlViewer
Then you can paste the following SQL Query in the textfield and click the "Execute DDL/DML Statement" button.

Here's the SQL for changing the SeasonNumber:
UPDATE Songs SET SeasonNumber = "0"||SeasonNumber WHERE (SeasonNumber != "" AND SeasonNumber NOT LIKE "0%" AND SeasonNumber < 10);

And for the EpisodeNumber:
UPDATE Songs SET EpisodeNumber = "0"||EpisodeNumber WHERE (EpisodeNumber != "" AND EpisodeNumber NOT LIKE "0%" AND EpisodeNumber < 10);

It worked for updating my Episode numbers (a few were skipped) but it moslty failed when running it on the Season numbers. I guess it is because it is not a number field but a text field so you cannot check for something "less than 10" (< 10).

I guess you can run the following query:
UPDATE Songs SET EpisodeNumber = "01" WHERE EpisodeNumber = "1";

and repeat that 9 times, each time incrementing the number. So "01" becomes "02" and = "1" becomes "2".

I think I'm going to do that now, it's faster than selecting everythin in the viewer and updating it.

Please make a backup of your database first!
Here's a nice script by Trixmoto: Backup

[tommycrock]

Thanks for that, although looking at it it's to add a leading zero, I'm wanting to delete them. Got any SQL for that?

[tooone7]

Will figure something out when I get home.

[Vyper]

The options for this script allows you to remove the leading zero instead of adding it. Will that do what you want?

I don't have MM4 installed yet so I don't have a way of checking it myself.

[tooone7]

Thanks for that, although looking at it it's to add a leading zero, I'm wanting to delete them. Got any SQL for that?

Sorry to get back only now.

I have a solution for you! To remove the leading zero you can use the following SQL for SeasonNumber:
UPDATE Songs SET SeasonNumber = replace(SeasonNumber, 0, "") WHERE SeasonNumber = "01" OR SeasonNumber = "02" OR SeasonNumber = "03" OR SeasonNumber = "04" OR SeasonNumber = "05" OR SeasonNumber = "06" OR SeasonNumber = "07" OR SeasonNumber = "08" OR SeasonNumber = "09";

and for EpisodeNumber use:
UPDATE Songs SET EpisodeNumber = replace(EpisodeNumber, 0, "") WHERE EpisodeNumber = "01" OR EpisodeNumber = "02" OR EpisodeNumber = "03" OR EpisodeNumber = "04" OR EpisodeNumber = "05" OR EpisodeNumber = "06" OR EpisodeNumber = "07" OR EpisodeNumber = "08" OR EpisodeNumber = "09;

Thats all i can think off for now.

I hope Bex will update the script soon

[tooone7]

The options for this script allows you to remove the leading zero instead of adding it. Will that do what you want?

I don't have MM4 installed yet so I don't have a way of checking it myself.

Hi Vyper the problem is that me and Tommy want this script to also add/remove leading zeros on Episode and Season numbers for our series and the current version of the script does not yet cater for that.

[tommycrock]

Sorry to get back only now.

Ditto...

I have a solution for you!

Worked perfectly , well almost, little tweak needed, a final " for the episode numbers

Thanks very much

[tooone7]

Worked perfectly , well almost, little tweak needed, a final " for the episode numbers

Thanks very much

Oh i see at the end there was a missing qoute

No problem glad i could help

[Harlequin123]

Any way to get this working in MM 4.x? Doesn't seem to show up in the application anymore.

[gpzbc]

I know it doesn't help you at all, but it is working for me in MM4.

[AnteBios]

Hello,


Bex thank you for this script.

Using MM 3.2.5.1306 however, no changes are made to the filename. I don't find the option to do that. Do I need to do a "auto-organize files" after running your script?


Thanks.

[TrueHarlequin124]

@gpzbc You're right, I see it now. It seems it doesn't show up in the main menu anywhere anymore, just in the right-click context menu.

[tommycrock]

no changes are made to the filename. I don't find the option to do that.

I'm using MM4 but it works for me without doing anything else. Do you have filename ticked in Tools-> Options | Library > Case & Leading Zero Fixer?

[mlr]

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…

Nice to Have Request:
1. An Option add the Disc # (1) to Track # (24) making the Track # (124)
2. The ability to Tick the Tracks or\and Columns to be changed…

Besides the q & N2Hs, THANK YOU for this excellent add-on, it took care of about 98% of my tweaking needs.

[Vyper]

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…

Tools -> Options -> Case & Leading Zero Fixer ... taking 'the' out of the little words list and putting 'The' in the forced case list should work ...