Action: Format value
Field: TITLE
Formatstring: $regexp(%TITLE%,'^([^(]+?)\s\(([^(]+?)\)\s\(([^(]+?)\)$','$1 ($2) [$3]')
From:
AAA (BBB) (CCC)
To:
AAA (BBB) [CCC]
Filter:
TITLE MATCHES "^([^(]+?)\s\(([^(]+?)\)\s\(([^(]+?)\)$
Other approach:
Begin Action Group Test_2011#20111226.Test.Round.Square.BracketsAction #1
Actiontype 7: Import tag fields (guess values)
Source format __: %TITLE%
Guessing pattern: %TEMP1%÷(%TEMP2%)÷(%TEMP3%)
Action #2
Actiontype 5: Format value
Field ______: TITLE
Formatstring: %TEMP1%'÷('%TEMP2%')÷['%TEMP3%']'
Action #3
Actiontype 9: Remove fields
Fields to remove (semicolon separated): TEMP1;TEMP2;TEMP3
Note: Replace each special ÷ character with one space character.
End Action Group Test_2011#20111226.Test.Round.Square.Brackets (3 Actions)
DD.20111226.1600.CET