How to remove leading common text from ARTIST field of an album

Support
1

Hey guys
Hope all of you are doing great.
I have been trying to find the answer to this query since long
A lot of my albums have VARIOUS ARTISTS\ before the ARTIST tag.
I have tried whatever i could find on the support pages but unable to..
an option that somewhat worked was
quick actions
replace with expression
^\s*[VARIOUS ARTISTS\]+\s*
but this removes many characters from the artists field itself

the original field looks like = VARIOUS ARTISTS\Kishore Kumar\Rajesh Roshan
upon using the above expression it gets converted to = \Kishore Kumar\ ajesh Roshan
(the R goes missing , similarly from among other artist's names very many characters get omitted
also I would ideally like to remove the \ from between names of the artists as well..

any help would be appreciated

Thanks
AB

2

Use an action of the (simple) type "Replace"
Search string: Various Artists\
Replace with:
(leave emtpy)

The square brackets in your regular expression have a special purpose and if you escape the opening bracket but do not escape the closing one as well, I don't know what effects that will have on your text.

Are you sure that you have

(single backslash) and not
VARIOUS ARTISTS\\Kishore Kumar\\Rajesh Roshan
(double backslash)

3

yes you are correct its double backslash not single..
also the filenames are also like VARIOUS ARTISTS - Koi Roko Na (so no artists names there as well - just thought of clearing this )

also i tried replace VARIOUS ARTISTS\ as well as VARIOUS ARTISTS with double slash at the end
it doesn't do anything

4

This means that you have several fields of the type "ARTIST" - to check, see the extended tags dialogue Alt-T for a single file. In case of

you should see 3 fields of the type ARTIST.
To treat multi-value fields, see the function with $meta

and the action to merge

or remove duplicate fields

Decide, what you want to do: remove or merge.
I would recommend "Merge". Use a different separator from \\ e.g. ;.
And then repeat the simple replace with the
Search string: Various artists;