Copy values between fields with regexp

Support
#1

I have a bunch of files with generic album names like "_misc". In the comment field, they have the real album name, formatted as "album[REAL_NAME]". There may be other text in the comment field before/after the album[] declaration.

So I want to run this regexp on the comment field: album[([^]]+)] and place the match ($1) in the album field, overwriting its current value. How can I do this?

#2

Make a new action:

Action type: Format value
Field: ALBUM
Format string: $regexp(%comment%,'album[([^]]+)]',$1)

#3

That leaves any text before or after the "album[...]" match, which I would think isn't wanted. The following only keeps the text within the square brackets:

$regexp(%comment%,'^.album[([^]]+)].$',$1)

#4

Here is a proposal using the action 'Guess values' ...

Action: Guess values
Source format: %COMMENT%
Guessing pattern: %DUMMY%album[%ALBUM%]%DUMMY%

Example ...
From:
COMMENT=... formatted as "album[REAL_NAME]". There may be other text ...
To:
ALBUM=REAL_NAME

DD.20121030.2128.CET

#5

That worked, thank you everyone!