Import file renaming

[Gwyver]

Apologies in case this has already been covered in the forum (though I've not been able to resolve the question using forum search).

Olympus RAW files have the following format: _mdd''''.orf
where m = month taken ('..9, A,B,C)
dd = day taken ('1..31)
'''' = file number ('''1..9999)

For consistency with my DAM system I wish to rename these with a format as follows:- yyyymmdd_''''.orf
ie date taken (from EXIF) followed by the original file number as above.

I've tried to use the Lr Filename Template Editor to achieve this, but so far without success.
(I used "{Date(YYYYMMDD)}_{Filename number suffix}" but this treats the entire last 6 digits of the original filename as the number suffix, whereas I only wish to use the last 4 digits.)
Is there any way to edit a template to get the format I want?
TIA

Chris.

 

[Brad Snyder]

Just to be clear, the 'dd' part of the original filename is getting stuffed into the {suffix} token?

 

[Gwyver]

Just to be clear, the 'dd' part of the original filename is getting stuffed into the {suffix} token?

Brad,
Yes that's correct.

 

[Brad Snyder]

OK, I have some of those Oly files, let me go play.

I know Mark Sirota has done some work with custom templates, maybe he'll be by with an idea. (No pressure, Mark)

 

[Mark Sirota]

Baton passed, Brad.

I'm very surprised by the dd getting stuck into the Filename Number Suffix element, if the month is not also included. (Is the month included if it is a digit, not a letter?)

There's no way that I know of to take a substring of any element. Another request recently came up for that, someone wanting to take a substring of the folder name to use in the filename. That sounds like a good feature request.

It would appear that the filename token elements cannot be customized. I suspect, as I hinted above, that "Original number suffix" and "Filename number suffix" just take the last substring of the name that is all digits.

 

[Denis Pagé]

Olympus RAW files have the following format: _mdd''''.orf

So we just left the "B" month and are starting the "C" month today (december 1st). So it seem that Lightroom is considering that as long as by reading the filename from right to left it does see numbers, those are the serial number.

While Mark is looking at the "TranslatedStrings" file, can you look in your Olympus manual to see if you are really stuck with this naming sheme from the camera?

 

[Gwyver]

So we just left the "B" month and are starting the "C" month today (december 1st). So it seem that Lightroom is considering that as long as by reading the filename from right to left it does see numbers, those are the serial number.

While Mark is looking at the "TranslatedStrings" file, can you look in your Olympus manual to see if you are really stuck with this naming sheme from the camera?

Hi Denis, Mark,
Yes, we are in the "C" month now, and unfortunately also stuck with this Olympus defined naming scheme.
Apologies for now replying more swiftly, I'm in the UK and thus some hours ahead of you. I appreciate your efforts on this one.