File Exculsions in SFTP - regular expressions

[former_member223443]

Hi PI experts,

Could you please suggest the Regular Expression to be used for excluding a file to pick from SFTP and process from PI. It's most urgent, need your help.

There are some files with BIAC20130209.SRL1234569.Pro, PI need not to pick the files with extension .PRO (Processed files), and it should pick the remaining files BIAC*.
Example files to pick: BIAC1234abc.SNL12345.ok; BIAC1234abc.SNL12345.dlv, e.t.c

Currently I am using the regular expression for all the files, but I need an REGEX to achieve the above exclusion of one file and picking up remaining, kindly suggest your views and experiences.

Regards,

Sri

[gagandeep_batra · Accepted solution]

Check the below thread that may help.

http://scn.sap.com/thread/3249516

and try following link also:

http://www.fusion-reactor.com/fr/help/creating_a_regular_expression_exclusion.htm

and check with     [^.PRO]

Regards

Gagan

[former_member223443 · Accepted solution]

Hi Gagandeep,

Thanks for the information, will check this and update you.

-sri

[Former Member · Accepted solution]

Hi,

Negative lookahead (?!\.PRO) will help but I am not sure how to write regular expression with that.

Regards,

Beena

[Former Member · Accepted solution]

Hi,

Please check if this works:

^BIAC((?!\.Pro$)[\w.])+$

Regards,

Beena

[smavachee]

Refer this blog by Rajasekhar for REGEX use cases..

I will suggest before getting into REGEX, refer below blog by Mickael and also check the last link provided, it may help you.

Exclude files in a Sender File Adapter

Be careful with parameter entries.

Hope it helps.!

Regards,

Sunil

[former_member223443]

Hi Sunil,

I am using SFTP adapter in my sender channel. So the exclusion mask is not available, so I am going for regular expressions for this.

Thanks,

Sri