Replace specific character in tags and filename

[tomy91]

Hello dear Mp3tag community,

I purchased old Pioneer CDJ-200 turntables to practice mixing in my bedroom. It supports MP3 CDs, I burned a few and found out that the players stop with an 8304 error when the filename or any of the ID3 tag fields (mostly Artist, Title and Genre) contains "&" symbol. As the latest firmware update doesn't solve this problem and Pioneer won't give a f**k for a 15 years old legacy device, I'll have to adjust and edit the filenames and tags.

I think regexp is the thing I want but I'm not familiar with it.

Can someone please write me a line that replaces "&" with "and" anywhere in the filename or ID3 tag field(s)?

And one more quick question:
My tag field INITIALKEY contains values like "1A", "5B", "11A". How to convert them with a "0" in front of those values with a single number before the letter A or B? "01A", "05B", "11A"

I'd appreciate any help.

[ohrenkino]

@tomy91

that replaces "&" with "and" anywhere in the filename

Use an action of the type "Format value" for _FILENAME
Format string: $replace(%_filename%,&,and)
I would not replace the & in the tags.
If you create new filenames for that player, enclose the whole pattern that you use for the filename with the $replace() function so that the filename format string may look like this:
$replace($num(%track%,2)_%title%,&,and)

[ohrenkino]

@tomy91

INITIALKEY contains values like "1A", "5B", "11A". How to convert them with a "0" in front

Use an action of the type "Format value" for INITIALKEY
Format string: $regexp(%initialkey%,^(\d.)$,0$1)

[tomy91]

Thanks, mate, will give it a try this evening.

@ohrenkino

I would not replace the & in the tags.

Can I ask why? I have to do it to avoid error on my CDJs. I see no problem there because I'm editing the filename and tags not for my original files in library but the copies made only for burning to CD which I delete afterwards.

[ohrenkino]

I just fancy to keep the data in the tags as close to the original as possible...
Filenames have so many restrictions in respect to valid characters that the only criterion that they have to fulfill is: be unique.
So why should any other tag "suffer" from the restrictions for the filenames?

[tomy91]

Unfortunately the error appears even with a good filename (without "&") if there's "&" somewhere in the artist, title, album or genre field. But as I said - no problem cause I'm creating copies to edit, burn and delete afterwards.

[ohrenkino]

I think if you substitute %_filename% with %_all% then the action should replace all ampersands everywhere.
If that does not work, use %_tag% for all the tag data.

[tomy91]

Replacing "&" with "and" works excellent.

But

@ohrenkino

$regexp(%initialkey%'^(\d.)$,0$1)

this one writes [ SYNTAX ERROR IN FORMATTING ]` in the field. I'm too dumb to debug.

[ohrenkino]

@ohrenkino

$regexp(%initialkey%'^(\d.)$,0$1)

should read
$regexp(%initialkey%,^(\d.)$,0$1)

[ohrenkino]

@ohrenkino

with %_all% ...%_tag% for

I have to correct this:
It is only possible to use _TAG or _ALL for actions like "Replace" or "Replace with regular expression". Using %_tag% only shows the tag version.

[tomy91]

Thanks for the quick and detailed help @ohrenkino, I got what (I thought) I needed!

In the end I ruined few more CDs to find out that "&" wasn't the actual problem. Pioneer CDJ-200 and possibly other players from the same generation doesn't like MP3 files that have Xing stream embedded. I solved it by downloading MP3 Diags and removing all Xing streams from the files before writing them to the CD.

[rochlech]

I'm having trouble finding the option to change the "/" characters to "," - can anyone help me do this?

[ohrenkino]

@rochlech

I'm having trouble

What have you done so far?
Are really treating / and not \\?
For the latter, see

Replacing Double-back-slash With Semi-colon-Space

Sorry if this is explained elsewhere. I could not find it. Tags like Composer and Style have up to several values (e.g. Michael Preston Barr\\Dion McGregor or World Fusion\\Latin Jazz\\Afro-Cuban\\Afro-Cuban Jazz\\Cuban Traditions) MP3tag only displays the first value in the list and I do not see the rest of the values. I wish to convert from \\ to ; (semi-colon followed by a space) as a list separator. MP3tag displays all the values when saved like Michael Preston Barr; Dion McGregor or …

[rochlech]

Thanks for the answer but I still can't locate the problem - I only use program to mass rename files
It looks like this.

David Guetta/Alesso/Madison Love
I want to change to:
David Guetta, Alesso, Madison Love

[ohrenkino]

Which function do you use?
Could you please supply a screenshot of the function that you do not get to work?

In the Converter, use $replace(%artist%,/,', ') to modify the output from the field ARTIST

[ItHurtsWhenTCPIP]

ohrenkino's solution works perfectly - if what you want is the file name to have commas and the tag data to retain the slashes.

If you want the tag and the filename to both display commas (not slashes) you will need to create a couple of actions for use before doing the file name Converter function:

Action: Replace
Field: ARTIST
Original: /
Replace With: ,

Action: Merge duplicate fields
Field: ARTIST
Separator: ,

Which action works depends on if the data in ARTIST is populated as:

• one field, names have a slash between them
• multiple fields, the slash character is the separator

Once the data is formatted with commas in the tag, then the Convert function will work with the simple use of %artist%

[rochlech]

Yes, of course - my menu is in Polish but don't worry, I can change it to English, it's about mass change - setting a template for such names so that they are changed without special characters that Windows cannot use, in this case it is "/"

[ohrenkino]

Now it would be nice to see the function with which you try to rename the files.
Or perhaps to shorten that a little bit:
Have you tried to use

@ohrenkino

$replace(%artist%,/,', ')

instead of the the plain %artist%?

[rochlech]

Finally finally!!!

How can I repay You master?