20160810_Amazon-OK-invoice.pdf => Swap, order, rearrange the parts

xoksx · 2020-06-14 17:07

Hello,

This is the case:
My files have the following naming convention:

YYYYMMDD_COMPANY - OK - Subject.pdf ==> e.g: 20160810_Amazon - OK - invoice.pdf

I'd like to change that:

Amazon - OK - 20160810 - invoice.pdf

How can I manage this via ReNamer?

Thank you in advance.

Best regards

Last edited by xoksx (2020-06-14 17:08)

Stefan · 2020-06-14 18:56

Hi and welcome.

FROM:
20160810_Amazon - OK - invoice.pdf
TO:
Amazon - OK - 20160810 - invoice.pdf

USE:
1) Remove: Remove all "_Amazon - OK" (skip extension)
2) Insert: Insert "Amazon - OK - " as Prefix (skip extension)
3 - [Preview]
4 - [Rename]

For more details see http://www.den4b.com/wiki/ReNamer

HTH?

xoksx · 2020-06-14 20:14

Thank you.
Amazon was just one example.
I have more than 10,000 files with the following naming convention: ==> YYYYYMMDD_COMPANY - OK - Subject.pdf

So how can I move the date after "OK - "? ==> COMPANY - OK - YYYYYMMDD - Subject.pdf

Rnmr · 2020-06-14 21:21

@xoksx "So how can I move the date after "OK - "? ==> COMPANY - OK - YYYYYMMDD - Subject.pdf"

It is there in Stefan's example.
Did you test/preview it on one of your files?

Step 1 (remove) will cause the date number to be at the beginning all by itself, momentarily.
Step 2 will cause the date to be after 'Company - OK - ...'

Just do each 'step => preview' one-at-a-time.

You would do the same thing for a different company but change the company name (provided they all follow the same format).

However, again, if they follow the same format, you should not be concerned with changing any names/words/numbers/characters/etc.
if you do this:

2 Rules:

First Rule- Replace (no quotes)

Find
'_'

Replace
' - '

tick 'first' and 'skip extension'

Second Rule- Rearrange (no quotes)

tick 'exact pattern...'

'| | | | | | |'

New Pattern
'$3 $4 $5 $6 $1 $2 $7'

tick 'skip extension'

It also works if you modify the second rule to,
[no qoutes]

tick 'Delimeters'

' - '

New Pattern
$2 - $3 - $1 - $4

tick 'skip extension'

There are probably some other variations but this is a start.
Hopefully I understand you and this helps.

Last edited by Rnmr (2020-06-14 22:18)

den4b · 2020-06-14 22:21

I would do it with a single Rearrange rule, like so:

> Rearrange: Split by exact pattern of delimiters "_", " - OK - ", New pattern "$2 - OK - $1 - $3" (skip extension)

Input:

20160810_Amazon - OK - invoice.pdf
20160810_Another company name - OK - another invoice.pdf

Output:

Amazon - OK - 20160810 - invoice.pdf
Another company name - OK - 20160810 - another invoice.pdf

Assuming that " - OK - " appears in all files.

Stefan · 2020-06-15 06:15

xoksx wrote:

Amazon was just one example.

Ahh, now!

Fine, another way to the above mentinoed...

FROM:
20160810_Amazon - OK - invoice.pdf
YYYYYMMDD_COMPANY - OK - Subject.pdf
20160810_Another company name - OK - another invoice.pdf

TO:
Amazon - OK - 20160810 - invoice.pdf
COMPANY - OK - YYYYYMMDD - Subject.pdf
Another company name - OK - 20160810 - another invoice.pdf

USE:
1) Replace rule: Find all "_" Replace " - " (skip extension)
2) Rearrange rule: Split by delimiters " - ", New pattern "$2 - $3 - $1 - $4" (skip extension)
Don't use the "..." quotes, and note the well used spaces.
3 - [Preview]
4 - [Rename]

Or use one Regular Expressions rule to do that all together in one step:
Expression "(\d{8})_(.+? - )(.+? - )(.+)" Replace "$2$3$1 - $4" (skip extension)

For more details about the rules see http://www.den4b.com/wiki/ReNamer

Rnmr · 2020-06-15 17:18

@stefan

"USE:
1) Replace rule: Find all "_" Replace " - " (skip extension)
2) Rearrange rule: Split by delimiters " - ", New pattern "$2 - $3 - $1 - $4" (skip extension)
Don't use the "..." quotes, and note the well used spaces.
3 - [Preview]
4 - [Rename]"

Is that another way of doing it or the same as what I suggested?...just curious.

Stefan · 2020-06-15 20:08

Hi Rnmr,

yes, you have had that exactly same idea already before I posted that,
if I take now a deeper look at your example, I see no differences to mine.
Sorry, I didn't spotted that fact beforehand.

den4b Forum

#1 2020-06-14 17:07

20160810_Amazon-OK-invoice.pdf => Swap, order, rearrange the parts

#2 2020-06-14 18:56

Re: 20160810_Amazon-OK-invoice.pdf => Swap, order, rearrange the parts

#3 2020-06-14 20:14

Re: 20160810_Amazon-OK-invoice.pdf => Swap, order, rearrange the parts

#4 2020-06-14 21:21

Re: 20160810_Amazon-OK-invoice.pdf => Swap, order, rearrange the parts

#5 2020-06-14 22:21

Re: 20160810_Amazon-OK-invoice.pdf => Swap, order, rearrange the parts

#6 2020-06-15 06:15

Re: 20160810_Amazon-OK-invoice.pdf => Swap, order, rearrange the parts

#7 2020-06-15 17:18

Re: 20160810_Amazon-OK-invoice.pdf => Swap, order, rearrange the parts

#8 2020-06-15 20:08

Re: 20160810_Amazon-OK-invoice.pdf => Swap, order, rearrange the parts

Board footer