Joined: 24 Aug 2011
|Posted: Wed Aug 31, 2011 9:27 am Post subject: Issues with date formating: Plugin Datereformater
|Selection before Plugin Datereformater starts ?
The plugin for date formating is very helpful. But, i noticed some formating, which destroys the original “meaning”. Though, i need to identify & filter out these files.
Because i noticed more than one case, i need to define more filter criteria, to avoid a wrong reformat. Instead of using the name filter, where i can only use one filter criteria, is there a option in the search pattern ?
Overall, this date formatting is not easy, due to many potential combinations.
I think, to define one set of regex to cover all cases is not possible. The target probably should be, to find rules for the majority.
I see the need for manual check of the search results, delete out the still correct ones and the push the rename button.
Below, some observations, maybe you have further ideas...
*Convert dates using date formatter in*Prefix*
Options -> Date Formatter: Custom Format %d.%m.%Y
Format the suitable digits to a european date format e.g. 04.09.2011
Can i enter in Row 1 to X further filter criteria (instead use name filter), before the Pre-defined date formater row is executed ?
Example cases with wrong results, if i have only row 1:
Adress 10.06.2010.xls => Adress 06.10.2010.xls
=> this files is correct. Though, i would need to filter out all files with dates in xx.xx.xxxx format
My solution idea:
Use name filter: Exclude all files with 2 dots in prefex with xx.xx.xxxx format:
This name filter is not the perfect one yet. It filters too much.
But, somehow this filter
Is there a possibility, to filter out all files, which have the xx.xx.xxx or xx.xx.xx date format ?
Development portfolio 2009-2010.pptx => development portfolio 20.10.2009.pptx
How can i filter out these such files, which year range ?
My test in name filter, which did not work:
Migration 20.04.09.doc => Migration 00.09.2004.doc
This is a logical problem. How should the system know, which digit position is the year.
My solution idea:
Overall, I should first replace / add the century, if a the last 2 digits are 01, 02, 03, ..10,11
(I do not have files, which are before year 2000) before using the plugin dateformater
When i enter in name filter .*, then i get this curious result...
360° Solution Review - 20.11.2009.pptx => 360° Solution Review - 20.09.2011.pptx
=> if can filter out the correct files, then plugin would not do such change
Thanks for your help,