All
I have a specific issue I'm struggling with and need help from the learned folk out there, as I'm not very good at regular expressions.
I have and TITLE and ALBUM fields with a / in them, and want to delete the characters efore and after the /, for example:
TITLE and ALBUM both contain
Symphony No. 2 in A Major Op. 68/II.Recitative&Romance:Adagio
and I want them to be:
TITLE
II.Recitative&Romance:Adagio
ALBUM
Symphony No. 2 in A Major Op. 68
All help gratefully received
Kevin
kbriddon:
...not very good at regular expressions.
...
TITLE and ALBUM both contain
Symphony No. 2 in A Major Op. 68/II.Recitative&Romance:Adagio
and I want them to be:
TITLE
II.Recitative&Romance:Adagio
ALBUM
Symphony No. 2 in A Major Op. 68
If both fields contain the same data, you split one field to become the 2 fields with an action of the type "Guess values" for e.g. %title% (or %album% if they are both the same)
Input string: %title%
Guessing pattern: %album%/%title%
If you are not quite sure about the equal contents, then create 2 actions of the type "Guess values"
1: Input string: %title%
Guessing pattern: %dummy%/%title%
2: Input string: %album%
Guessing pattern: %album%/%dummy%
No regular expressions required.
ohrenkino:
If both fields contain the same data, you split one field to become the 2 fields with an action of the type "Guess values" for e.g. %title% (or %album% if they are both the same)
Input string: %title%
Guessing pattern: %album%/%title%
If you are not quite sure about the equal contents, then create 2 actions of the type "Guess values"
1: Input string: %title%
Guessing pattern: %dummy%/%title%
2: Input string: %album%
Guessing pattern: %album%/%dummy%
No regular expressions required.
Superb, works a treat, and no reg exp's to baffle me.
Many Thanks