If you try the string with your sample title - does it work?
I tried it only with your example, so it should.
If you find that also, great. If not, you would have to see where the difference is.
And then you have to see what the real data in TITLE looks like ...
The expression should be: $replace($regexp(%TITLE%,(.*?)\((\d+)/(\d+)/(\d+)\),$1 ($3==$2==19$4)),==1==,JAN,==2==,FEB,==3==,MAR,==4==,APR,==5==,MAY,==6==,JUN,==7==,JUL,==8==,AUG,==9==,SEP,==10==,OCT,==11==,NOV,==12==,DEC)
But there are other titles in my collection with different song names and different dates.
So I like to find a solution that does the whole batch with different dates as input and the specific dates as output.
I Know A Lot (5/25/79 Version)
I Do Know (4/14/79 Version)
I Know Not (4/8/79 Version)
And I'd like to have as a result:
I Know A Lot (25MAY1979 Version)
I Do Know (14APR1979 Version)
I Know Not (8APR1979 Version)
Now I am very close to what I want. Sometimes there is version in brackets and sometimes not. So I am looking for a insignificantly broader solution.
With my last shown code (the small modification of your code (I put %TITLE% instead of the real song name part and I omitted the following bracket) but it works quite well as I get:
(with the original filename which was:)
I Know I'm Not Wrong (8/13/79 Version)
I apply the last code and I get:
I Know I'm Not Wrong (13AUG1979 Version)
So the date part has been taken care of thanks to you!
There are two spaces between the song name and the opening bracket.
I would like to have one only there.
And then I'd like to have a broader command where it doesn't matter if there are letters after the date or not.
Maybe there is a fill argument for ignoring the rest to come inside the brackets?
Thanks a lot!
You could try: $replace($regexp(I Know (4/25/79 Version),(.*?)\((\d+)/(\d+)/(\d+.*)\),$1 ($3==$2==19$4)),==1==,JAN,==2==,FEB,==3==,MAR,==4==,APR,==5==,MAY,==6==,JUN,==7==,JUL,==8==,AUG,==9==,SEP,==10==,OCT,==11==,NOV,==12==,DEC)