5 Replies Latest reply: Nov 9, 2017 1:06 AM by Anil Babu RSS

    Excel file name as Primary Key

    Madhumitha C

      Hello All,

      I have few excel files from which I should be extracting the data.

      The excel file name is in the below format.

      Test dashboard PKC00002 Health Checks_31May17.xlsx

       

      While extracting data from the file, how do I extract the primary key from the name of the file. In the above example, it would be "PKC0002"

       

       

      Thanks in advance.