INTERACT FORUM

More => Old Versions => Media Center 15 (Development Ended) => Topic started by: Snarglefarg on February 09, 2011, 01:33:22 am

Title: Undo "Move Article to End"
Post by: Snarglefarg on February 09, 2011, 01:33:22 am

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.

Title: Re: Undo "Move Article to End"
Post by: mark_h on February 09, 2011, 02:04:50 am

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

Title: Re: Undo "Move Article to End"
Post by: Snarglefarg on February 09, 2011, 02:21:03 am

That works great. Thanks!

Title: Re: Undo "Move Article to End"
Post by: Niacin on February 09, 2011, 03:52:36 am

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

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

Title: Re: Undo "Move Article to End"
Post by: mark_h on February 09, 2011, 03:56:31 am

Quote from: Niacin on February 09, 2011, 03:52:36 am

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

Title: Re: Undo "Move Article to End"
Post by: Niacin on February 09, 2011, 04:17:23 am

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.

Title: Re: Undo "Move Article to End"
Post by: mark_h on February 09, 2011, 04:20:28 am

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

Title: Re: Undo "Move Article to End"
Post by: Niacin on February 09, 2011, 04:37:51 am

Quote from: mark_h on February 09, 2011, 04:20:28 am

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

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