Print

Please login or register.
1 Hour 1 Day 1 Week 1 Month Forever
Login with username, password and session length

[epianist]

Dear all,
would you pls. help me to create a suitable regex function for unswap names remaining brackets at the end:
It can be one or more semicolon separated entries...
1.) now the composer tag looks like: Williams, Roderick (b1965);Tavener, Sir John (1944-2013)
2.) result from =Unswap([Composer]): Roderick (b1965) Williams; Sir John (1944-2013) Tavener
3.) my target would be after Unswap: Roderick Williams (b1965); Sir John Tavener (1944-2013)

Does somebody know how to achieve this? Thanks a lot.
Best, epianist