18 Replies Latest reply: Feb 7, 2017 8:42 AM by John Blomqvist RSS

    Extract the last 6 characters from a file name? (file will be a table loaded)

    John Blomqvist

      Hi all,

       

      How do I get the last 6 characters from a file name?

       

      For example I may have:

       

      C:\Users\Monthly FIle 31012016.xlsx

       

      I would like to get the bold bit from the file path.

       

      Esentially this is a table I am loading but I need the date to record how up to date the data is.

       

      I imagine this can be stored as a variable.

       

      Any idea how I can do this please?