1 Reply Latest reply: May 25, 2009 6:00 PM by Oleg Troyansky RSS

    Load last version of Excel files

      Hi all,
      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

      20090325,MARCH,DATA-20090325.XLS,0
      20090331,MARCH,DATA-20090331.XLS,0 <-
      20090430,APRIL,DATA-20090430.XLS,0
      20090430,APRIL,DATA-20090430-1.XLS,1
      20090430,APRIL,DATA-20090430-2.XLS,2 <-

      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!