Print

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

[goose2]

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?

[mark_h]

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

[goose2]

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