#11 2017-01-03 09:38

Stefan
Moderator
From: Germany, EU
Registered: 2007-10-23
Posts: 1,161

Re: Rename formula for dates

skylinekiller wrote:

That seemed to work perfectly.  but I had about 50 of each that had a slightly different name set up and I didn't notice it until now

01_armin_van_buuren_-_a_state_of_trance_193_21-04-2005-tt
01_armin_van_buuren_-_a_state_of_trance_264_(di.fm)_2006-08-31-tt

I am still trying to get the the same output "ASOT ### (yyyy-mm-dd) Pt #.ext"

I fee like that expression you gave is is some secret formula to build a time machine... lol



For "01_armin_van_buuren_-_a_state_of_trance_193_21-04-2005-tt.ext"
I changed one of the RegEx quantifiers from '+' to '*'
(Wiki: http://www.den4b.com/wiki/ReNamer:Regul … ifiers.29)
^0*([1-9]+).+_trance_(\d\d\d)_.+(\d\d)-(\d\d)-(\d{4})-tt$
^0*([1-9]+).+_trance_(\d\d\d)_.*(\d\d)-(\d\d)-(\d{4})-tt$
Now that works for both cases, with and without additional text between "trance-NUMBER" and "date".



For "01_armin_van_buuren_-_a_state_of_trance_264_(di.fm)_2006-08-31-tt.ext"
you could utilize the "Reformat Date" rule first,
(Wiki: http://www.den4b.com/wiki/ReNamer:Rules:ReformatDate)
or change the order of the RegEx "Subexpressions" matching groups "(\d\d)-(\d\d)-(\d{4})"
(Wiki: http://www.den4b.com/wiki/ReNamer:Regul … pressions)
and add another RegEx rule with that re-ordered expression for both date format.



 


Read the  *WIKI* for HELP + MANUAL + Tips&Tricks.
If ReNamer had helped you, please *DONATE* to Denis or buy a PRO license. (Read *Lite vs Pro*)

Offline

#12 2017-01-03 14:17

skylinekiller
Member
Registered: 2016-08-07
Posts: 15

Re: Rename formula for dates

Ok, I have reordered the dates to reflect yyyy-mm-dd.  I read the expressions apge the best I could and did some trial and erros, but were all failures.  The two different types i have left are below (230 left with part 1 and 2s)


01-armin_van_buuren_-_a_state_of_trance_410-sbd-2009-06-25-tt
01_armin_van_buuren_-_a_state_of_trance_267_(di.fm)_2006-09-21-tt

According to the expression you provided in your previous post
^0*([1-9]+).+_trance_(\d\d\d)_.+(\d\d)-(\d\d)-(\d{4})-tt$
ASOT $2 ($5-$4-$3) Pt $1

So am I correct to say that I only need to be concerned with the expression and NOT the replace.  The replace will remain the same?
From reading the expression page I did my best to change it to
^0*([1-9]+).+_trance_(\d\d\d)_.+(\d{4})-(\d\d)-(\d\d)-tt$     I moved the (\d{4}) in the beginning since that is the new renamed format of the date.  This did not work.  I also tried
^0*([1-9]+).+_trance_(\d\d\d)_.+-sbd$(\d{4})-(\d\d)-(\d\d)-tt$    Same as above, but used sbd$ to remove it.  This was a fail too.

Offline

#13 2017-01-03 15:27

Stefan
Moderator
From: Germany, EU
Registered: 2007-10-23
Posts: 1,161

Re: Rename formula for dates

>>>Ok, I have reordered the dates to reflect yyyy-mm-dd.
I thought "dd-mm-yyyy" is the main format?
But anyway...



The "$1" Subexpressions-references
are counted from left to right as there are written,
and give back what you have matched within the (..) expression.




So for "^0*([1-9]+).+_trance_(\d\d\d)_.+(\d{4})-(\d\d)-(\d\d)-tt$"

--- ([1-9]+) will be stored in $1
--- (\d\d\d) will be stored in $2
--- (\d{4})-(\d\d)-(\d\d) will be stored in $3 and $4 and $5


So you have to re-order the 'replace' too:

ASOT $2 ($3-$4-$5) Pt $1

to get the wanted "ASOT ### (yyyy-mm-dd) Pt #.ext" format.







- - - Again for clarity:


"01-armin_van_buuren_-_a_state_of_trance_008_(id-t_radio)_03-08-2001-tt"
Expression: ^0*([1-9]+).+_trance_(\d\d\d)_.*(\d\d)-(\d\d)-(\d{4})-tt$
Store Part# in $1, Title# in $2, day in $3, month in $4 and year in $5
Replace: ASOT $2 ($5-$4-$3) Pt $1



and

"01-armin_van_buuren_-_a_state_of_trance_410-sbd-2009-06-25-tt"
Expression: ^0*([1-9]+).+_trance_(\d\d\d)_.+(\d{4})-(\d\d)-(\d\d)-tt$
Store Part# in $1, Title# in $2, year in $3, month in $4 and day in $5
Replace: ASOT $2 ($3-$4-$5) Pt $1




 


Read the  *WIKI* for HELP + MANUAL + Tips&Tricks.
If ReNamer had helped you, please *DONATE* to Denis or buy a PRO license. (Read *Lite vs Pro*)

Offline

Board footer

Powered by FluxBB