2586051 - FileAdapter : How to use complex wildcard patterns in the FORCE_FILENAME_PATTERN setting to exclude extra files in the folder

When using the FileAdapter, customers can use a % as a wildcard in the FORCE_FILENAME_PATTERN setting in the CFG file.  The FileAdapter will then read every file in the folder that matches that wildcarded string as one virtual table.

Customers often have a scenario where an external process copies files in to the FileAdapters' data folder, and the files have a timestamp appended to the filename.  For example, FORCE_FILENAME_PATTERN=SALES_% will match all files that are dropped in monthly:

SALES_01_2017
SALES_02_2017
SALES_03_2017

However, sometimes a simple wildcard is not enough.  Let's say, for example, that along with the files above, each SALES file also has a corresponding descriptive file of the same name, but with a .sum extension.  You'd like to exclude those files from virtual table.

SALES_01_2017
SALES_01_2017.sum
SALES_02_2017
SALES_02_2017.sum
SALES_03_2017
SALES_03_2017.sum

SAP HANA Database, Smart Data Access, Smart Data Integration, File Adapter, regular expressions, virtual table, case sensitive, SDI , KBA , HAN-DP-SDI , SAP HANA smart data integration (SDI) , How To