I would like to consolidate various text fields.
For example, I would like to integrate the ENGINEER field into INVOLVEDPEOPLE and then delete it.
Duplicates should be avoided or removed.
I have attached the data for a song as an example.
The two instances of ENGINEER are contained in INVOLVEDPEOPLE and should be removed.
If there is an ENGINEER named ‘Albert Einstein’, it should be added to INVOLVEDPEOPLE.
You could ...
Convert>Tag-Tag for INVOLVEDPEOPLE
Format string: $meta_sep(involvedpeople,\\)\\$meta_sep(engineer,==)
Convert>Tag-Tag for INVOLVEDPEOPLE
Format string: $replace($meta_sep(involvedpeople,\\),==,' (Engineer)\\')
and then apply an action of the type "remove duplicate fields" for INVOLVEDPEOPLE but tick the option to remove only those with identical contents
Just a sidemark:
You have many Multivalue-Fields of INVOLVEDPEOPLE. The standard of the tagfield INVOLVEDPEOPLE looks like this:
That means that the standard for this type of field mainly exists to avoid Multivalue-Fields or user-defined fields: There is a scheme to combine these in 1 Textfile.
