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

[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

[Vyper]

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

[mlr]

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

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

[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?

[Vyper]

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

[mlr]

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)

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

[tommycrock]

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!)

[DocWeini]

Is this script still under development?