Seperate the year field from the title


#1

Hi folks,

I want to remove the year from the "title" and copy it to the "year" field. How can I achieve this ?

For e.g.

Original Title: Nostalgia ft. Masta Ace (2007)
New Title: Nostalgia ft. Masta Ace
Year: 2007

Original Title: Check Yo Self (Remix) ft. Das Efx (2001)
New Title: Check Yo Self (Remix) ft. Das Efx
Year: 2001

Original Title: Give It 2 You (Remix) (1995)
New Title: Give It 2 You (Remix)
Year: 1995

Thanks in advance :rolleyes:


#2

Action: Guess values
Source format: %TITLE%
Guessing pattern: %TITLE% (%YEAR%)

DD.20111113.0755


#3

Thanks DetlevD

I tried to use Format value with,

Field: %YEAR%
Format String: $regexp(%TITLE%, '^(.+)\s(([0-9]{4}))$','$2')

It didnt seem to work though. Any reason why it could be ? Atleast i know there is an alternative now :slight_smile:


#4

Also "Guess values" doesnt work when you have,

Test String (Remix) (1995)

It splits this to,

Title: Test String
Year: Remix) (1995


#5

Yes, you are right.

Try this ...
Action: Guess values
Source format: $regexp(%TITLE%,'^(.+)\s((.+))$','$1===$2')
Guessing pattern: %TITLE%===%YEAR%

... or try this excentric innovative action group ...

Begin Action Group Test_2011#20111113.GuessValues

Action #1
Actiontype 7: Import tag fields (guess values)
Source format __: $reverse(%TITLE%)
Guessing pattern: )%YEAR%( %TITLE%

Action #2
Actiontype 5: Format value
Field ______: YEAR
Formatstring: $reverse(%YEAR%)

Action #3
Actiontype 5: Format value
Field ______: TITLE
Formatstring: $reverse(%TITLE%)

End Action Group Test_2011#20111113.GuessValues (3 Actions)

DD.20111113.0950.CET


#6

Wow :w00t: Thanks a bunch

Its working like a charm

A++++++++++ your answer