Print

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

[Beltran]

Got this situation where I have some songs that have a combination of the Artist + Album name in the Album field, and other songs that have just the Album name in the Album field.  I need to clean these up because they are causing duplicates.   The format is consistant in that it will have a "Name - Album", so if I have wild card search and replace I could fix it.  But I don't seem to be able to find such a feature or combination of features that will help me correct it.

Any suggestions?

[rick.ca]

For files with [Album] in that form, set some unused field (say [Comment]) to =ListItem([Album],1,/ - ). That should result in the proper value for Album. Set [Album] =[Comment] and then delete [Comment].

[Beltran]

Trying to figure out where I use this.  I found the Add Expression feature but when I use that it creates a new field and does not use the real 'Comment' field.

This also does this for all the entries.  Even if I select a group it still applies the expression to all records. 

[marko]

You don't need to shuffle between fields... Simply take the first expression given by rick above, namely =ListItem([Album],1,/ - ) (be sure to use all of the blue text) and paste it right into the album field. Press enter, and the job is done.

Try one or two before going wholesale, and when you're comfortable, select all affected files and repeat the steps.

There's a brief intro to using expressions for tag manipulation in this way on the wiki

-marko.

[rick.ca]

Simply take the first expression given by rick above, namely =ListItem([Album],1,/ - ) (be sure to use all of the blue text) and paste it right into the album field.

Just to clarify...This works—there's no need for my intermediate step of putting the values in another field. I'm only in the habit of doing so because I'm nervous about changing many values until I see the results of the expression. In most cases, it's easier to do as marko suggests, and if anything goes wrong just Undo it.

[Beltran]

Thanks for the tips all.  98,500 entries changed.