14 Replies Latest reply: Jun 26, 2015 3:20 PM by Виталий Чуприна RSS

    How load data from file name?

    Виталий Чуприна

      Hi guys,

       

      I received files without date inside, so I need to load it from filename, but problem that date in following format:

       

      GenF JUNE WK 3.xlsx

       

      In this case how I should determine week ending date for I example I know that JUNE WK 3 = 2015-06-20.

      I think I should create calendar and then check the week number and month.

      Please advise the best way.

       

      Thanks,

      Vitaliy