2 Replies Latest reply: Jul 23, 2012 11:24 AM by Ionut Biliuti RSS

    Load date from day field and folder name

    Ionut Biliuti

      Hi to everybody,

       

      In a csv file like this:

       

      InvoiceNo,     Day

      123456,              1

      123457,              5   

      123458,              5

      123459,             14

      123460,             29

       

      located in folders like

      ..\2011_01\sales.csv.

      ..\2011_02\sales.csv,

      ..\2011_03\sales.csv

      etc...

       

      I have only a column containing the day of invoice  (1,2,3, ... 31)

       

      How can I load date column compose from folder name and Day field?

       

      Thanks,

      Ionut