Combining involved people roles

Hi All,
I currently have a number of tracks that have incorrect formatting of roles in the Involved people field.

The current format example is: Engineered by: Person one; Engineered by: Person two; Produced by: Person one; Produced by: Person two; Produced by: Person three; Mixed by: Person one; etc

I would like to format it so each person is listed under one entry of the respective role ie: Engineered by: Person one, Person two; Produced by: Person one, Person two, Person three; Mixed by: Person one; and so on. What would be the best way to achieve this. Greatly appreciate any feedback.

Regards Aaron

As there is no function to sort text, I do not see any way to group data together.
The only way I could think of is to do this outside MP3tag and prepare the data to that it can be read by a spreadsheet or a program to create tables.

This would be a simple export script to get text separated by tab characters and linefeeds instead of a semicolon:

$filename(involved.txt,utf-8)
$loop(%_filename%)$replace(%involvedpeople%,: ,$char(9),; ,$char(13)$char(10))
$loopend()

You would then arrange the text again, transform the table into a single line of text for each file and them import it with Convert>Text File-Tag.

Thank you so much for your work around. I will try this today and see how it goes. Greatly appreciate your assistance.

Would this be the same for data in the MUSICIAN CREDITS field? Ie Guitar: Person one; Guitar: Person two; change to
Guitar: Person one, Person two;

Regards Aaron

Yes, both applies to any other field - no sorting and the option to export the tag field's contents to a text file. You only have to replace the field name in the export. script

Edit August 2025: in the meantime MP3tag has got the $sort() scripting function.