8 Replies Latest reply: May 11, 2015 8:36 AM by anbu cheliyan RSS

    Scripting Issue

      Hi All,

       

      I have a list of filenames such as YYYY.MM Abc.xls, Xyz MM_YYYY.xlsx and many more.

      I want the following things o be separated from the filename:

      1. Date Format i.e. YYYY.MM for the first file, MM_YYYY for the second and so on.

      2. Filename excluding the date format i.e. Abc for the first file and Xyz for the second one.

       

      Is it possible? If yes, then how?

       

      Thanks,

      Asma