Some time ago I was given here a code like this
Format value: "TITLE": $regexp(%TITLE%,'(\[.*\])',\U$1)
And now I see it has flaw. Because something like this
Title 1 [xxx] + Title 2
is correctly changed to
Title 1 [XXX] + Title 2
Title 1 [xxx] + Title 2 [yyy]
is incorrectly changed to
Title 1 [XXX] + TITLE 2 [YYY]
instead of being changed to
Title 1 [XXX] + Title 2 [YYY]
Apparently the code sees the second >>]<< and so ignores the first >>]<< and second >>[<<
So my question is: how to change it, so it will stop executing itself after each >>]<< and start again after another >>[<<?
And also: how can I find now all the CAPITALIZED TITLES?