INTERACT FORUM

Please login or register.

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

Author Topic: How to replace "&" with ";" in bulk.  (Read 303 times)

baldo

  • World Citizen
  • ***
  • Posts: 216
How to replace "&" with ";" in bulk.
« on: January 18, 2024, 10:21:34 am »

Thanks to a HIGHLY helpful person here on this forum, I am working on tidying up my MC library.

I have several tracks that are labeled as Artist "A & B" and I would like to replace these to show artist as "A ; B". (and sigh replaced by semi colon)

I understand that this is better for MC especially when it comes to search results.

So I would like to replace the "&" with a ";".

What is the text that I need to enter so that MC and do this on mass for a whole load of selected files?

Many thanks for your help on this in advance.
Logged

MrBiff

  • World Citizen
  • ***
  • Posts: 143
Re: How to replace "&" with ";" in bulk.
« Reply #1 on: January 18, 2024, 10:31:35 am »

Example if you wanted to change the Artist field:

Select the file(s), right-click on any one of the Artist values from one of selected files, select Rename (or use F2), and in the field, enter:

Code: [Select]
=replace([Artist], / &/ , ;/ )
Logged

zybex

  • MC Beta Team
  • Citizen of the Universe
  • *****
  • Posts: 2362
Re: How to replace "&" with ";" in bulk.
« Reply #2 on: January 18, 2024, 10:45:43 am »

Instead of renaming the artists one by one you can do it for all artists in bulk using the Tag Editor.
Select all files (or a subset), open the Tag Editor panel, and enter MrBiff's formula on the Artist field (replacing the "Varies").

Perhaps you should make a backup before trying this.
Logged

baldo

  • World Citizen
  • ***
  • Posts: 216
Re: How to replace "&" with ";" in bulk.
« Reply #3 on: January 19, 2024, 01:20:07 pm »

Thanks Mr Biff,

That code worked perfectly. Just what I needed and saved me many hours of typing.
Logged
Pages: [1]   Go Up