Change from DDMMYYYY to YYYYMMDD

cronos · 2011-06-13 03:36

Sorry for my English.
Hi I would like to know how to change above subject.
I have files something like this:
MyWordSchedule-23-04-2011-Rev.1.0.doc

And i would like change to:
WordSchedule.Rev1-2011-04-23.doc

How I able to do that?
If possible to have a guide screenshot how to do it?

Thank you.

Last edited by cronos (2011-06-13 03:40)

Stefan · 2011-06-13 18:44

Hi and welcome cronos

FROM:
MyWordSchedule-23-04-2011-Rev.1.0.doc

TO:
MyWordSchedule.Rev1-2011-04-23.doc

You can use Regular Expressions > http://www.den4b.com/wiki/ReNamer:Rules:RegEx

Or use the Rearrange Rule from the latest ReNamer beta > http://www.den4b.com/wiki/ReNamer:Rules:Rearrange

See Example 1,Task: Swap parts of name at > http://www.den4b.com/wiki/ReNamer:Rules … e_Examples

Tip: Press Shift+A to see the Analyze window
where you can paste in your example string(s) and see what happens by applying the rules.
This way you can test all you want without messing up your real files.

For your example
MyWordSchedule-23-04-2011-Rev.1.0

use Rearrange, Split using Delimiters "-"

which gives you this parts
$1 = MyWordSchedule
$2 = 23
$3 = 04
$4 = 2011
$5 = Rev.1.0

You can test this by using the following as "New Pattern":
$1 \ $2 \ $3 \ $4 \ $5 \ $6 \ $7 \ $8 \ $9
Which gives you:
MyWordSchedule \ 23 \ 04 \ 2011 \ Rev.1.0 \ \ \ \ .doc

For your example rearrange them in the output "New Pattern" like:
$1.$5-$4-$3-$2

to get:
MyWordSchedule.Rev1-2011-04-23.doc

- - -

FROM:
MyWordSchedule.Rev1-2011-04-23.doc
TO:
WordSchedule.Rev1-2011-04-23.doc

depends how you want this.

For example you can use Rule Delete to delete the first two signs.

All in all you have to use two rules here:
1) Rearrange: Split by delimiters "-", New pattern "$1.$5-$4-$3-$2" (skip extension)
2) Delete: Delete from Position 1 until Count reaches 2 (skip extension)

.

den4b Forum

#1 2011-06-13 03:36

Change from DDMMYYYY to YYYYMMDD

#2 2011-06-13 18:44

Re: Change from DDMMYYYY to YYYYMMDD

Board footer