9 Replies Latest reply: Jan 13, 2017 2:25 PM by Dave Melillo RSS

    Create New Fields using File Name

    Dave Melillo

      I have many csv files I need to load with a standard naming convention ... examples are:

       

      200704-jenkins

      200705-jenkins

      200706-jenkins

       

      I would like to load all fields and created two more fields

       

      PERIOD = first 5 characters of file name (i.e 200704)

       

      SUBJECT = characters after hyphen ( - ) (i.e jenkins)

       

      I also need to turn the PERIOD into a date that can be used by Qlikview for time series analysis.

       

      Any help is appreciated.

       

      Thank you,

       

      - dave