Print

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

[wietster]

Hello,

Is there way to remove the duplicate genres from a expression column.

Hip-hop;R&B;Hip-Hop;Rap;Pop;Hip-Hop;R&B

This how i like it to be.

R&B;Hip-Hop;Rap;Pop

thnx

Wietster

[RoderickGI]

Select the file. Edit the Genre field.

If there is more than one file with the same erroneous Genre, open the "Audio > Files" View, in the search box enter:
[Genre]=[Hip-hop;R&B;Hip-Hop;Rap;Pop;Hip-Hop;R&B]

Then edit the Genre field.

You might need to muck around with the search term a bit, because the files have duplicates Genre. If the above doesn't work, try:
[Genre]=[R&B;Hip-Hop;Rap;Pop]

Once you find all the affected files, just editing the Genre field for them should force MC to remove the duplicates.

[zybex]

You can also just select many/all files (with or without duplicates) and type this in the Genre field (Tag panel):

Code: [Select]

=listclean([genre],1)

[wietster]

Thnx zybex,

=listclean([genre],1) this does  the trick

greetings

Wietster

[RoderickGI]

Ah yes, that saves searching for them, which was probably the hardest part.

I was too focused on the fact that Genre cleans itself when you edit it to think about the new functions.

Nice.