I have this:
TITLE.....................................................................ARTIST
Lascia ch'io pianga from Rinaldo (Handel)............ A To Z Of Opera
I want this:
TITLE.....................................................................ARTIST
Lascia ch'io pianga from Rinaldo............................Handel
Move ''Handel'' to Artist
Remove ''()''
Remove ''A To Z Of Opera''
Thanks for your help, but if I want to move one parenthesis It works perfect, but some times some songs have 2 parenthesis and this is whats happens:
ORIGINAL
TITLE....................................................................ARTIST
Che gelida manina (La Bohème) (Puccini).............A to Z Opera
AFTER
TITLE....................................................................ARTIST
Che gelida manina..............................................La Bohème) (Puccini
Let me know if there is a fix, if not, I will fix mannualy each song, Thanks a lot
1.Action: Guess valuesSource format :$reverse(%TITLE%)Guessing pattern:)%ARTIST%(%TITLE%==> ARTIST = iniccuP==> TITLE =)emèhoB aL(aninam adileg ehC2.Action: Guess valuesSource format :$reverse(%TITLE%' *** '%ARTIST%)Guessing pattern: %ARTIST%*** %TITLE%==> ARTIST = Puccini==> TITLE = Che gelida manina(La Bohème)
Unset Filter [F3]
... or ...
Action: Guess valuesSource format:$trimRight($replace(%TITLE%,') (',')***'),')')==> "Che gelida manina(La Bohème)***Puccini"Guessing pattern: %TITLE%***%ARTIST%==> TITLE = Che gelida manina(La Bohème)==> ARTIST = Puccini
... or ...
1.Action: Format valueField : ARTISTFormatstring:$regexp(%TITLE%,'^(.+)\s\((.+)\)$','$2')==> ARTIST = Puccini2.Action: Format valueField : TITLEFormatstring:$regexp(%TITLE%,'^(.+)\s\((.+)\)$','$1')==> TITLE = Che gelida manina(La Bohème)
... or ...
1.Action: Guess valuesSource format : %TITLE%Guessing pattern: %DUMMY%(%DUMMY%)(%ARTIST%)==> ARTIST = Puccini2.Action: Format valueField : TITLEFormatstring:$left(%TITLE%,$sub($strrchr(%TITLE%,'('),2))==> TITLE = Che gelida manina(La Bohème)