This content has been marked as final. Show 5 replies
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.