den4b Forum

skylinekiller

Member

Registered: 2016-08-07

Posts: 15

Rename formula for dates

How can I get the following to look like the following?

Asot752 - 25-02-2016 - A State of Trance 752 (SBD), Armin Van Buuren

This is what I want
ASOT 752 (2016-02-25)

Last edited by skylinekiller (2016-12-30 13:34)

den4b

Administrator

From: den4b.com

Registered: 2006-04-06

Posts: 3,374

Re: Rename formula for dates

What have you tried so far?

These rules will work for your example:

1) Replace: Replace all "Asot752 -" with "ASOT 752" (skip extension)
2) Reformat Date: Convert to "yyyy-mm-dd" from "dd-mm-yyyy", whole words only, skip extension
3) Regular Expressions: Replace expression "\b(\d{4}-\d{2}-\d{2})\b" with "($1)" (skip extension)
4) Delete: Delete from Delimiter " - " until the End (skip extension)

---

A story of software development, and how it all evolves into Live vs Pro
Request a Wiki account | Reporting spam and abuse | Why did I get banned?

skylinekiller

Member

Registered: 2016-08-07

Posts: 15

Re: Rename formula for dates

The Asot572  have many different versions example

Asot573
Asot574
Asot600

skylinekiller

Member

Registered: 2016-08-07

Posts: 15

Re: Rename formula for dates

Here is what I am trying

Stefan

Moderator

From: Germany, EU

Registered: 2007-10-23

Posts: 1,161

Re: Rename formula for dates

FROM:
Asot752 - 25-02-2016 - A State of Trance 752 (SBD), Armin Van Buuren.ext

TO:
ASOT 752 (2016-02-25).ext

THAT IS:
Take first word, split at first digit and insert space, upper case.
Take first three standalone digits and order the parts, put parentheses around.
Drop the rest.

USE RegEx Rule:
Expression: Asot(\d+) - (\d\d)-(\d\d)-(\d{4}).+
Replace: ASOT $1 ($4-$3-$2)

 

---

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*)

skylinekiller

Member

Registered: 2016-08-07

Posts: 15

Re: Rename formula for dates

Ok, here is the latest.  Not sure if this is the "real" way to do this, but I am achieving what I want.  This is pretty complicated to understand.   How can I get rif of the hyphen between the episode and date  example
ASOT 754 - (
to
ASOT 754 (

skylinekiller

Member

Registered: 2016-08-07

Posts: 15

Re: Rename formula for dates

Nevrmind, I just replaced
- (
with
(

skylinekiller

Member

Registered: 2016-08-07

Posts: 15

Re: Rename formula for dates

I stumbled onto another issue with similar files.  I am trying to rename 200+ files with the below file names.  I cant's seem to get it to work with labeling the "parts"

01-armin_van_buuren_-_a_state_of_trance_008_(id-t_radio)_03-08-2001-tt       I want ASOT 008 (2001-03-08) Pt 1
02-armin_van_buuren_-_a_state_of_trance_008_(id-t_radio)_03-08-2001-tt       I Want ASOT 008 (2001-08-03) Pt 2
01-armin_van_buuren_-_a_state_of_trance_025_(id-t_radio)_06-12-2001-tt       I want ASOT 025 (2001-12-06) Pt 1
02-armin_van_buuren_-_a_state_of_trance_025_(id-t_radio)_06-12-2001-tt       I want ASOT 025 (2001-12-06) Pt 2

Stefan

Moderator

From: Germany, EU

Registered: 2007-10-23

Posts: 1,161

Re: Rename formula for dates

01-armin_van_buuren_-_a_state_of_trance_008_(id-t_radio)_03-08-2001-tt       I want ASOT 008 (2001-03-08) Pt 1
02-armin_van_buuren_-_a_state_of_trance_008_(id-t_radio)_03-08-2001-tt       I Want ASOT 008 (2001-08-03) Pt 2
01-armin_van_buuren_-_a_state_of_trance_025_(id-t_radio)_06-12-2001-tt       I want ASOT 025 (2001-12-06) Pt 1
02-armin_van_buuren_-_a_state_of_trance_025_(id-t_radio)_06-12-2001-tt       I want ASOT 025 (2001-12-06) Pt 2

FROM:
01-armin_van_buuren_-_a_state_of_trance_008_(id-t_radio)_03-08-2001-tt.ext
02-armin_van_buuren_-_a_state_of_trance_008_(id-t_radio)_03-08-2001-tt.ext
01-armin_van_buuren_-_a_state_of_trance_025_(id-t_radio)_06-12-2001-tt.ext
02-armin_van_buuren_-_a_state_of_trance_025_(id-t_radio)_06-12-2001-tt.ext

TO:
ASOT 008 (2001-08-03) Pt 1.ext
ASOT 008 (2001-08-03) Pt 2.ext
ASOT 025 (2001-12-06) Pt 1.ext
ASOT 025 (2001-12-06) Pt 2.ext

THAT IS:
- take and store the leading number (but no zeros) as $1.
- take and store number behind 'trance_' to $2.
- take and store three groups of digits before '-tt' to $3, $4 and $5.
New Name:
- Add prefix 'ASOT '
- Add stored digit group $2
- Rearrange the three digit groups and surround by parentheses: ($5-$4-$2).
- Add ' Pt '
- Add stored number $1

USE RegEx Rule (http://www.den4b.com/wiki/ReNamer:Rules:RegEx):
Expression: ^0*([1-9]+).+_trance_(\d\d\d)_.+(\d\d)-(\d\d)-(\d{4})-tt$
Replace: ASOT $2 ($5-$4-$3) Pt $1
[x] Skip extension

 

---

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*)

skylinekiller

Member

Registered: 2016-08-07

Posts: 15

Re: Rename formula for dates

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