SFTP file name issue

[Former Member]

Hello experts,

We have a scenario where we are using SAP SFTP adapter to pick up the files from SFTP folder which has the following format.

File name format: expenses_CES_SAE_v3_SAP_t00457hk3a_20160809080424.txt

What should be the filename schema for picking up the files.

At present i am using "^expenses[\w\d]{1,20}.txt" to pick up the files, but its not working.

Please suggest how to pick the files of this kind.

[Former Member]

Hi Srinivas ,

please use {1,50} Instead of {1, 20} in your expression .

You can use Regular Expression Tester to test your regexp whether it is correct or not.

[former_member186851]

Hello Srinivas,

You need to follow regex.

Try as per the below link

SFTP adapter File Name pattern | SCN