INTERACT FORUM

Please login or register.

Login with username, password and session length
Advanced search  
Pages: [1]   Go Down

Author Topic: MC expression remove duplicate genre  (Read 663 times)

wietster

  • Member
  • *
  • Posts: 2
MC expression remove duplicate genre
« on: September 06, 2020, 09:11:37 am »

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
Logged

RoderickGI

  • MC Beta Team
  • Citizen of the Universe
  • *****
  • Posts: 8186
Re: MC expression remove duplicate genre
« Reply #1 on: September 06, 2020, 04:39:25 pm »

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.
Logged
What specific version of MC you are running:MC27.0.27 @ Oct 27, 2020 and updating regularly Jim!                        MC Release Notes: https://wiki.jriver.com/index.php/Release_Notes
What OS(s) and Version you are running:     Windows 10 Pro 64bit Version 2004 (OS Build 19041.572).
The JRMark score of the PC with an issue:    JRMark (version 26.0.52 64 bit): 3419
Important relevant info about your environment:     
  Using the HTPC as a MC Server & a Workstation as a MC Client plus some DLNA clients.
  Running JRiver for Android, JRemote2, Gizmo, & MO 4Media on a Sony Xperia XZ Premium Android 9.
  Playing video out to a Sony 65" TV connected via HDMI, playing digital audio out via motherboard sound card, PCIe TV tuner

zybex

  • MC Beta Team
  • Citizen of the Universe
  • *****
  • Posts: 2567
Re: MC expression remove duplicate genre
« Reply #2 on: September 07, 2020, 02:27:17 am »

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)
Logged

wietster

  • Member
  • *
  • Posts: 2
Re: MC expression remove duplicate genre
« Reply #3 on: September 07, 2020, 02:57:37 am »

Thnx zybex,

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

greetings

Wietster

Logged

RoderickGI

  • MC Beta Team
  • Citizen of the Universe
  • *****
  • Posts: 8186
Re: MC expression remove duplicate genre
« Reply #4 on: September 07, 2020, 03:47:49 pm »

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.
Logged
What specific version of MC you are running:MC27.0.27 @ Oct 27, 2020 and updating regularly Jim!                        MC Release Notes: https://wiki.jriver.com/index.php/Release_Notes
What OS(s) and Version you are running:     Windows 10 Pro 64bit Version 2004 (OS Build 19041.572).
The JRMark score of the PC with an issue:    JRMark (version 26.0.52 64 bit): 3419
Important relevant info about your environment:     
  Using the HTPC as a MC Server & a Workstation as a MC Client plus some DLNA clients.
  Running JRiver for Android, JRemote2, Gizmo, & MO 4Media on a Sony Xperia XZ Premium Android 9.
  Playing video out to a Sony 65" TV connected via HDMI, playing digital audio out via motherboard sound card, PCIe TV tuner
Pages: [1]   Go Up