Get data based on file name

[Anonymous]

I've searched the forum for a while now but can't seem to find a solution to my problem. 

What I'm trying to achieve is collecting data in to a master based on the file name. I have a huge folder containing thousands of excel files. I wanna extract data from specific files containing "project" in the file name. The files themselves are built with the same layout.

Hopefully this can be done. 

[itsmekamal]

Further to the question posted by arduaj, my query is after i select a particular folder wherein there are 50 plus files containing data of each day's stock prices. I want to retrieve the contents of a particular day's file based on the date that i have entered in my excel sheet. I do not want to go to query editor everytime and change the date in the filter criteria.

Could you guide me with a solution please.

Thanks in advance.

[Anonymous]

Yes to some extent, although when I add a new file to the folder with the same layout it doesnt import it. It gives me an alert that a column is missing. What i did in the editor is that i removed some rows of each file to only keep the data i need.

That might be the problem?

[mahoneypat · Accepted solution]

Using the Folder or SharePoint Folder connectors, you can get a list of all the files.  You can then Filter the file name column for text that contains "project".  In the query editor, click on the pull-down arrow on the right of the column header and select Text Filters/Contains ...  You could also filter first to a specific subfolder (if needed) by filtering that column.

If this works for you, please mark it as the solution.  Kudos are appreciated too.  Please let me know if not.

Regards,

Pat