I have to load only the last revision of excel files in a directory. They are named like:
DATA-20090325.XLS, DATA-20090331.XLS, DATA-20090430.XLS, DATA-20090430-1, DATA-20090430-2.XLS
In the example I have to load only the newest revision (if there are) of the last day of month (in bold font).
At the moment i have created a script that create a table with this data
DATA | MONTH | FILENAME | VERSION
But I can't load ONLY the latest version of the last "elaborate-day" in every month. (They have an arrow in example above)
Any suggestion? Many Thanks!