Haags
Joined: 24 Aug 2011 Posts: 6
|
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...
Current setup:
Row 1:
Pre-defined command:
*Convert dates using date formatter in*Prefix*
Options -> Date Formatter: Custom Format %d.%m.%Y
My target:
Format the suitable digits to a european date format e.g. 04.09.2011
My question:
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:
Problem 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.
(.*)(\d{2}[^\.]\d{2}[^\.]\d{4}).*
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 ?
Problem 2:
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:
.*(^2009).*
.* ^(2009-2010).*
Problem 3:
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
Problem 4:
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,
Stefan |
|