#1 : 31/12-23 00:27 Julia
Posts: 1
|
Hi - I am hoping someone can help me to change the date format when using <ExifTool:CreateDate> for my movie files.
<ExifTool:CreateDate> gives the following date format: yyyy_mm_dd hh_mm_ss (e.g., 2023_09_21 17_06_53). I instead want the date to have the format: mmm dd yyyy (e.g., Sep 21 2023) with no timestamp. Is there a way to do this? Thank you all so much for your help! |
#2 : 28/02-24 10:20 Delta Foxtrot
Posts: 285
|
Reply to #1:
Hey Julia, Sorry for the late reply. I just recently got re-interested in this forum and came across your inquiry. You've probably figured this out for yourself by now, but here's a synopsis of ONE way to do it. Didn't know where in your filename you wanted the Creation date; at the start may be simplest but anywhere will do. I chose the end of the filename. Here's the drill: ADD Method: Add the ExifTool date at index 0 with "backwards" checked. I put an underscore in front of the tag to mark its beginning; best if you use something not already in the filenames. Replace method: (to get the basic date in number form) Replace: _(\d{4}).(\d{2}).(\d{2}).{15} Replace with: _\2 \3 \1 Use regular expressions Note the underscore in position 1. Replace with whatever you used (if different) Now you create what is basically an array of month-number date-short-name pairs: List replace: Text to be replaced: Replace with: _01 Jan _02 Feb _03 Mar ... etc. Replace underscore if...bla bla bla. THIS is where the underscore might not be the best choice if you have other "_nn" occurrences in your filenames. That's it, although you can clean it up from there depending on your level of OCS (mine is high, I replaced the underscore with a space, etc.) Hope that helps (if you actually see it). Holla if you need information. Best, DF |