Remove certain characters from the MIDDLE of a tag

Support
1

Hello. I'm trying to do the following:

change this:
Symphony No. 6 in D major H 1/6, "Le Matin" - 1. Adagio-Allegro
to this:
Symphony No. 6 in D major "Le Matin" - 1. Adagio-Allegro

That is, I want to delete certain characters in the middle of a tag.

Thanks for any help.

2

Just perform an action with

REPLACE
FIELD tag you want to be check %title%
ORIGINAL H 1/6
REPLACE WITH leave it blank

3

Thanks Haldo,

I didn't explain fully. The characters "H 1/6" are not constant. They vary eg H 2/7 etc.

Anyway, I think I found the solution. I used the following:

FORMAT VALUE
FIELD: Title
FORMAT STRING: $mid(%title%,1,25)$mid(%title%,33,999)

It took a while to figure this out, but it seem to work.

Thanks anyway for your advice

4

If the pattern of the string that should get deleted is always "a letter, blank, number, slash, number, comma" then such an action of the type "Format value" would be more flexible as it allows the leading string to be of variable length:
Format string: $regexp(%title%,'. \d\/\d, ',)

5

THANKS!! That's exactly what I need.