Applying Regex Filtering on File Names in SFTP Sender Adapter – SAP Cloud Integration

When using the SFTP Sender Adapter in SAP Cloud Integration, you can filter files based on patterns. Regex filtering provides a powerful way to match specific file names when polling an SFTP server. Here’s how you can configure it:

Steps to Enable Regex Filtering

1. Directory Path: Provide the relative directory path to read files, e.g., parentdir/childdir.
2. Enable Regex Filtering Under Source Tab, select the Regex Filtering checkbox.This ensures the file name field is treated as a regular expression rather than a simple pattern.
3. Define File Name: Input your regex expression in the File Name field.

Regex Filtering Examples:

1. Match Specific Patterns: ^file\d+\.txt$ → Matches files like file1.txt, file123.txt.
2. Include Subdirectories: Use patterns like .*subdir.*\.csv to include files from nested directories.
3. Exclude Files: Combine patterns like ^(?!exclude).*\.xml to avoid files starting with "exclude".
4. Wildcard Equivalent: .*\.log → Matches all .log files.

Important Notes:

• Ensure the regex syntax is correct; invalid patterns may cause errors.
• A 5-second timeout is set for regex evaluation.
• Avoid overly complex patterns to ensure performance efficiency.

Example Configuration:

• Directory: data/input
• Regex Filtering: Checked
• File Name: ^report_\d{4}-\d{2}-\d{2}\.csv$Matches files like report_2024-06-17.csv.

Regex filtering in the SFTP sender adapter simplifies file processing by enabling precise control over which files to pick during polling. This is especially useful for dynamic integration scenarios where file naming follows a specific pattern.

Let me know if you'd like additional examples or configurations! ??

Reference https://help.sap.com/docs/integration-suite/sap-integration-suite/configure-sftp-sender-adapter#loio2de9ee58737247969eb7dc9e68b1b121__sftp_regex