SAP Knowledge Base Article - Preview

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

Symptom

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


Read more...

Product

SAP HANA smart data integration all versions

Keywords

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

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.