Is this script still under development?

[quote="mlr"]Is there a way to mark “[b]The[/b]” not to change to “the” in the following?
Adam and [b]The[/b] Ants, Adele & [b]The[/b] Raconteurs, Diana Ross & [b]The[/b] Supremes…
[/quote]
Using the SQL Viewer addin, you could try:
[code]UPDATE Songs SET Artist= Replace(Artist, ' the ', ' The ') WHERE Artist glob "* & the *" OR Artist glob "* and the *"[/code]
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!)

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%"

[quote="Vyper"]Did my suggestion do what you wanted regarding the word 'the'?[/quote]

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 [b]t[/b]he Soldier, [b]T[/b]he (Live)

Did my suggestion do what you wanted regarding the word 'the'?

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?

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.

Is there a way I can pin this to a toolbar?

Oh! Sorry, didn't realize that. That may be a toughie.

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 & [b]T[/b]he Supremes - Stop! In [b]t[/b]he Name of Love

[quote="mlr"]Is there a way to mark “[b]The[/b]” not to change to “the” in the following?
Adam and [b]The[/b] Ants, Adele & [b]The[/b] Raconteurs, Diana Ross & [b]The[/b] Supremes…[/quote]
Tools -> Options -> Case & Leading Zero Fixer ... taking 'the' out of the little words list and putting 'The' in the forced case list should work ...

Is there a way to mark “[b]The[/b]” not to change to “the” in the following?
Adam and [b]The[/b] Ants, Adele & [b]The[/b] Raconteurs, Diana Ross & [b]The[/b] Supremes…

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

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

[quote="AnteBios"]no changes are made to the filename. I don't find the option to do that. [/quote]
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?

@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.

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.