Get FileNames From Directories

[Lewzerrrr]

Hi,

I need to extract part of multiple file names from a directory, is this possible?

Let's say I have H:\Lewzerrrr\

In this directory I have multiple folders and inside these multiple files.

I need to go through each folder and extract partial string from the file name.

H:\Lewzerrrr\Value1\01_Value1_Value2.xlsx

I would need to extract "Value2", the format is the same for each file.

Any help is greatly appreciated.

Thanks,

 

[Scott T]

You can use power query (get and transform data) to get file names.

see
https://youtu.be/GyceQCW4gi0

I do not have power query at work but if you cannot extract the part you want in power query you can just use a formula in excel after you get the whole filename.