File sender adapter (FTP) regular expressions

[Former Member]

Hi everybody,

I Need to pick files with this format: "ABC_12345678.xml". (exactly 8 digits)

I'm trying to achieve this requirement with "File Name Mask" in the file adapter.

Regular expressions like "ABC_[0-9]{8}.dat" or "ABC_\d{8}.dat" seems not to work.

Does File adapter supports regular expressions? STFP is not available in my PI.

Currently i'm using "ABC_*.xml" in order to pick the files but i need to restrict more than that because files like 'ABC_ABC.xml' fix the pattern

Any solution?

Thanks in advance.

[iaki_vila]

Hi José Miguel,

I think Hareesh Game give to you a good way to restrict your selection. Also, you can try with OS command before or after, depending if you can use regular expressions with a ftp command (im not sure) or to delete the file that doesn't fill the regular expression.

Check this wiki: SAP XI File Adapter OS Command Line Feature - Process Integration - SCN Wiki

And may be this link could be helpful if you are under UNIX system: Learn Linux, 101: Search text files using regular expressions

Regards.

[Former Member]

Files with format "ABC_12345678.dat" not "ABC_12345678.xml", the extension is wrong in the OP.

[Harish]

I think the limitation of 8 char is not working, if you remove the 8 then it should work

ABC_[0-9].date

[Former Member]

Hi Harish,

ABC_[0-9].dat is not working.

Thanks.

[former_member184720]

AFAIK - You can only have the place holders but not the regular expression in File adapter.

You could try ABC_????????.dat and see if that helps

[RaghuVamseedhar]

Jose,

File/FTP channel accept * ? as place holders. SFTP channel accept regular expression for filename.

Defining Placeholders, File Name Masks, and Exclusion Masks - Advanced Adapter Engine - SAP Library

Configuring the SFTP Sender Channel - SAP NetWeaver Process Integration, secure connectivity add-on ...

[Harish]

Hi,

I see the issue with extension in regular expression, can you try the below Regular expressions

"ABC_[0-9]{8}.xml"

[Former Member]

Tested and not working...