INTERACT FORUM

More => Old Versions => JRiver Media Center 30 for Windows => Topic started by: baldo on January 18, 2024, 10:21:34 am

Title: How to replace "&" with ";" in bulk.
Post by: baldo 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.

Title: Re: How to replace "&" with ";" in bulk.
Post by: MrBiff 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], / &/ , ;/ )

Title: Re: How to replace "&" with ";" in bulk.
Post by: zybex 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.

Title: Re: How to replace "&" with ";" in bulk.
Post by: baldo 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.