Picking up a file using sender SFTP channel which has changing DATE in between

[Former Member]

The file that I need to pick up has the name <A>_<B>_<C>_<DATE>_<COMPANYCODE>_<FINAL><DATE>-<D>-<E>.ZIP

The unique fields in this file name are A,B,C and FINAL which I must include filename parameter to pick up the required file.

Please let me know what should I mention in the filename parameter.

[former_member190293]

Hi A B!

Try this: A_B_C_.*\FINAL.*\.zip

Regards, Evgeniy.

[dhivakar]

Normally this should work A_B_C_*FINAL*.zip. Can you first try simply * and check whether it picks any files from that folder?

[Former Member]

SFTP has different place holder i believe. * would have worked if it was FILE.

[dhivakar]

Can you try checking the channel by giving the full filename? If it picks then use .* (dot asterisk). It should work for sure.

I have live scenarios where it is working. If this is also not working, share you channel configuration.

[dhivakar]

If I understand your question correctly, you can *_<DATE>_<COMPANYCODE>_*<DATE>-<D>-<E>.ZIP can be given

Or please explain the requirement clearly.

Thanks

[Former Member]

no..DATE and company codes will change on a regular basis... the rest of the 4 things (A, B, C and FINAL) does not change in the file name which needs to be picked up by PI

The sample file would look like A_B_C_180418_1111_FINAL180418-D-E.zip or A_B_C_200418_2222_FINAL200418-D-E.zip

So I need to know what should I use in the file name parameter.

I have tried out few combinations like A_B_C_*FINAL*.zip and more..which didnt work.