I have a field 'Role' with, for example, the following entries:
Alt Vocals\\Alt Voice\\Alto Vocals\\Alto Guitar\\Soprano Vocals\\Soprano Voice\\Soprano Clarinet\\Soprano Saxophone
These should be standardized:
Alto Voice\Alto Voice\Alto Voice\Alto Guitar\Soprano Voice\Soprano Voice\Soprano Clarinet\Soprano Saxophon
Duplicate expressions should be avoided.
This doesn't work with replacement and my knowledge is too rudimentary for regex. Can someone help me?
The double backslash indicates that you have multi-value fields.
You would have to merge them first.
See this thread on the treatment of list with duplicate words:
Thank you, ohrenkino.
So i tried. The Problem is the replace. Soprono from Voice and Soprono from Clarinet gives: Soprono Stimmeklarinette and so on. I think i habe to do it mit regex. But I do not know how.
To merge fields, use an action:
specify semicolon space as separator.
Then apply the code from the linked thread.