Print

Please login or register.
1 Hour 1 Day 1 Week 1 Month Forever
Login with username, password and session length

[Snarglefarg]

Is it possible to undo the "Move Article to End" function (Tools > Library Tools > Clean File Properties)? I moved the article to the end several years back but would now like to move the article back to the beginning. So instead of: "Beatles, The" I now want "The Beatles".

Even if it's not completely automated, I can easily find all instances using the Query Search:
Name    ends with     , The

But I can't figure out how to remove it from the end and add "The" to the beginning.

[mark_h]

Here's one approach...

This expression would do it for 'Beatles, The', resulting in 'The Beatles'

=if(isequal(right([artist],5),/,/ The),The replace([artist],/,/ The,,),)

Probably best to use a smartlist to pull up all [artist] contains ', The' and apply it to the results... which you do by highlighting all entries to change and pasting my expression into the [artist] column of one entry

[Snarglefarg]

That works great. Thanks!

[Niacin]

You can simply toggle the articles on or off in the options.

Options, Tree and View, Sorting - there is a check box

[mark_h]

You can simply toggle the articles on or off in the options.

Options, Tree and View, Sorting - there is a check box

That just changes the way data is sorted for display, not the actual data...

[Niacin]

Personally, if I wanted to change the data, I'd use a temp playlist to display all the artists where there was a use of "The" and do a mass edit from within the playlist. I did as much when I decided to remove "The" from all artists. It took a couple of minutes, max.

[mark_h]

Yup.  That's essentially what my expression is used for. 

[Niacin]

Yup.  That's essentially what my expression is used for. 

Ah yes Mark - my doh moment - I re-read your post....properly!