Trimming Artist Field

Support
1

Hi,

How do I move all after a comma (artist field) to the end of (title field) and inside a parenthesis?

Example:

FROM THIS: John Wayne, Allen Douglas Rmx - My song

TO THIS:   John Wayne - My Song (Allen Douglas Rmx)

thank's in advance !!!

2

So, ARTIST looks like this: John Wayne, Allen Douglas Rmx
TITLE looks like this: My song

Result should be:
ARTIST: John Wayne
TITLE: My Song (Allen Douglas Rmx)
is that right?

I think 3 steps are necessary:

  1. Action of the type "Guess value" for ARTIST
    Guessing pattern: %artist%, %tmp_field%
    -> this moves the part following the comma to a user-defined field called TMP_FIELD

  2. action of the type "Format value" for TITLE
    Format string: %title% (%tmp_field%)
    -> this adds the contents of TMP_FIELD to TITLE

  3. action of the type "Remove tag field" for TMP_FIELD
    this removes the temporary field as it is not needed any more.

3
Action "Format value" Field: ARTIST Formatstring: $regexp(%ARTIST%,'^(.+?), (.+?) - (.+?)$','$1 - $3 ($2)') ... or ... Formatstring: $regexp(%ARTIST%,'^(.+?), (.+?)( - .+?)$','$1$3 ($2)') From: 'John Wayne, Allen Douglas Rmx - My Song' To : 'John Wayne - My Song (Allen Douglas Rmx)'

DD.20150730.1045.CEST

Ooops, ... this is not quite the solution for the given question.
DD.20150730.1125.CEST

4

does it really move parts of ARTIST to the end of TITLE as the OP requested if you only treat the ARTIST field?

5

No, I was wrong in understanding the problem. Thank you.

DD.20150730.1129.CEST

6
Swap trailing part from Artist to Title From ... ARTIST = 'John Wayne, Allen Douglas Rmx' TITLE = 'My song' To ... ARTIST = 'John Wayne' TITLE = 'My Song (Allen Douglas Rmx)' Proposal 1 1. Action "Guess values" Source format ..: %ARTIST% Guessing pattern: %ARTIST%, %TEMP% 2. Action "Format values" Field ......: TITLE Formatstring: %TITLE%' ('%TEMP%')' 3. Action "Remove fields" Fields: TEMP Proposal 2 1. Action "Guess values" Source format ..: %ARTIST% Guessing pattern: %ARTIST%, %TEMP% 2. Action "Guess values" Source format ..: %TITLE%' ('%TEMP%')===' Guessing pattern: %TITLE%===%TEMP% Proposal 3 Action "Guess values" Source format ..: $replace(%ARTIST%,', ','==='%TITLE%' (')')' Guessing pattern: %ARTIST%===%TITLE% Proposal 4 1. Action "Format value" Field ......: TITLE Formatstring: %TITLE%' ('$regexp(%ARTIST%,'^.+?, ',)')' 2. Action "Format value" Field ......: ARTIST Formatstring: $regexp(%ARTIST%,',.+?$',)

DD.20150730.1329.CEST