The case in conclusion 2 does not make sense in respect to splitting the field.
You simply copy the contents of albumartist to content group
Sorry, Could you explain what you mean?
What do you want to put into mixartist if there is no data in square brackets
I see what you mean
On PUBLISHER obviously goes nothing but on MIXARTIST should goes ABBA.
*I repeat this: I talk here about PUBLISHER because I want to move the data from ALBUMARTIST to MIXARTIST & PUBLISHER, not to CONTENTGROUP & MIXARTIST as I sayd before.
The problem here is that with the code you have provided I can only transfer the ALBUMARTIST data that includes at least 1 type of my indications ([vs. ...] , [aprx. ...] & [/theme from .../] ).
So I have 2 ways to proceed:
1st way, identify the songs where ALBUMARTIST includes at least 1 type of my indications & use the code you have provided to transfer & split the data to MIXARTIST & PUBLISHER, & identify the songs where ALBUMARTIST is just the "specific artist" (no indications) & just copy the data to MIXARTIST.
2nd way, copy the ALBUMARTIST data to MIXARTIST & PUBLISHER & then delete the indications on MIXARTIST field to just keep the "specific artist" data, & delete the "specific artist" on PUBLISHER field to just keep the indications.
In both ways I need to do 2 steps but I am wondering if is not more easy to proceed like on the 2nd way than the 1st.
If I have the ALBUMARTIST copyed to MIXARTIST & PUBLISHER do you know if i can just delete the data I want in both fields? How?
Or do you think there's another way more easy to do it?
Thank you!
That is completely up to you. But as you get the data from ALBUMARTIST - a field that most players use to keep an album together but hardly any player really reads and needs MIXARTIST and PUBLISHER I do not think that it is a good idea to delete ALBUMARTIST unless you have alternative data to set into ALBUMARTIST.
Or what do you intend to do?
For the discussion on easiness: I would use a filter to identify all the tracks with an opening square bracket and apply the action "Guess value".
And then I would invert that filter and treat the other files.
I assume that this will happen right now once in the lifetime of the existing files. So any kind of possible but rather elaborate and therefore difficult set of actions with conditions to match would be much less easy.
And all future files that you get won't need to split ALBUMARTIST into several fields as you would enter the data straightaway into the correct fields.
So, as you said that
where the 6th did not match the original data pattern, I would say that your problem is solved.