INTERACT FORUM

More => Old Versions => Media Center 12 (Development Ended) => Topic started by: goose2 on September 29, 2007, 03:29:56 pm

Title: search term help please?
Post by: goose2 on September 29, 2007, 03:29:56 pm

I've been trying to figure out a good way to display entries in my library that have accidentally had artist name entered both with and without the article "the". For example "Rippingtons" and "The Rippingtons". I'd like to clean this up but haven't found an easy way to display. Thanks for any suggestions?

Title: Re: search term help please?
Post by: mark_h on September 30, 2007, 03:09:02 am

Off the top of my head, without testing, you could probably use an expression field to do this:

http://www.jrmediacenter.com/DevZone/DBExpressions.htm

Something like, create a new field called "myartist" and define it with an expression

if(isequal(mid([Artist], 0,4),The ,1),mid([artist],4,-1),[Artist])

Then create a smartlist based on [myartist], but also add in [artist] to the display for comparison and then sort to float the artists with "The " to the top for cleaning.

Something like that!

Or, try Tree & View -> Sorting -> Ignore articles (a, an, the)

And see if you can sort in the same way I describe above.

Mark

Title: Re: search term help please?
Post by: goose2 on October 01, 2007, 02:15:17 pm

Thanks Mark.....ignore articles got me there.
Randy