SFTP adapter File Name pattern

[Former Member]

Hi Team,

Please help in forming regular expression for Filename in SFTP adapter.

I tried with [a-zA-Z0-9_], [a-zA-Z0-9_].*, [a-zA-Z0-9_].txt ...etc, which didn't worked.

The following are the different type of files available in same directory

CPT_PO_TEXT_%02-06-09%_%15-28-50%.txt

P20120927060000.xls

APZ_20120927_T05D.csv

AIMS_POL_151209_1741.TXT

The numeric values change day by day and have configured 4 sender comm channels.

Please let me know what pattern can be used to pick above mentioned files along with its extensions.

[Former Member · Accepted solution]

Hi,

If you just need to poll for file extensions then you could try something like this in your 4 comm channels:

([^\s]+(\.(txt))$)

([^\s]+(\.(xls))$)

([^\s]+(\.(csv))$)

([^\s]+(\.(TXT))$)

You could test your regular expressions using this online test tool:

http://www.nvcc.edu/home/drodgers/ceu/resources/test_regexp.asp

Example:

Regards, Trevor

[Former Member · Accepted solution]

Thanks alot Trevor,

It solved my problem ...