How To use Wild Card Characters in SAP SFTP Channel?

[Former Member]

Hi Experts,

   I am using SFTP Sender & Receiver Channel to Pick-up & Put some files on server in PI 7.3

in sender Channel ---> File Parameter ---> I want to use *.*  (Basically i want to send all the files of a particular folder.)

I am getting the following error.

Exception received: java.util.regex.PatternSyntaxException: Dangling meta character '*' near index 0 *bpc*.dbt.

as per requirement we should put the same file name in the target folder.

Secondly, after suceesful transfer I want to move this file from one location to another. How can i do this?

Pl. Note that I have used the AMA setting FileName as ticked.

Looking forward for some help.

Regards,

Umesh

[rakshithhm]

Hi Umesh,

For the error mentioned Dangling meta character '*' near index 0 *bpc*.dbt.

You can replace the filename as [A-Z,a-z,0-9]bpc[A-Z,a-z,0-9].*dbt

And to send all the files of a particular folder

Replace the Filename as ".*" (only dot and Asterisk)

Regards,

Rakshith HM

[Former Member]

Hi Umesh,

have you resolved your problem?

Regards

Kefei

[chrismills]

SFTP adapter uses regex for file expression so .* should work

http://help.sap.com/saphelp_nwposc/helpdata/en/2e/99f0fb5a9e45b3b148c90e87fafcd1/content.htm?framese...

ASMA will allow you to set the output name via the mapping but will need to have a reference to the original name, you might need to dig around and see if this is even pulled in by the sender adapter or not.

[Former Member]

hi,

  To generate the same file name in target side use ASMA properties....

   also crate a UDF using Dynamic Config...and there r so many blogs in SCN .referring

   the UDF.

                 I think the following thread would be helpful..........

                    *****  http://scn.sap.com/thread/2155045

Regards,

Anirban

[allamudi_loordh]

Hi Umesh,

can you please try with '*' only

or esle give *.CSV , *.txt,  use additional file concept.

http://help.sap.com/saphelp_nw73ehp1/helpdata/en/44/692ab8a4b633eae10000000a1553f6/content.htm

Regards,

Loordh.

[Former Member]

Hi All,

   How about moving the Sourcefile once transfereed to Target folder to some other folder.

which option i should used in Sender Channel?

Regards,

Umesh