How to Specify Regular Expression in Excel Source File Name
I want to load one or more Excel files from a folder into a table. The files could be of .xls or .xlsx extension.
So, in the file format, I need to specify the file name for taking both .xls and .xlsx files only for loading.
Currently I'm specifying it using wildcard as *.xls* . But, is there any other way so that i can keep it more specific.
Can we use regular expressions other than the basic wild cards here? Expecting your valuable suggestions.