on 01-06-2016 12:13 AM
Hi
I understand that the "filename" parameter for the SFTP adapter takes a regular expression.
I have a simple requirement, for 2 sender channels:
1) Select only files containing the string TEST anywhere in the filename
2) Select only files which do not contain the string TEST anywhere in the filename
I am unable to get this to work, even for the simple scenario 1. I have tried various regular expressions, but the result is always Found 0 files
If I change the value to .* it correctly retrieves all files in the directory, including those with TEST in the filename.
Any suggestions please?
Regards
Steve
Hello Steve,
I haven't used this. But can you try with the below option as per the note, I guess you need to give ".*TEST.*"
1988592 - SFTP Adapter not picking files with *
Cause
The syntax to include placeholders in the file name field on the SFTP adapter is different from the syntax used on the File adapter.
Resolution
In order to work with placeholders on the file name parameter the value needs to be separated by a dot ".", such as "test.*.xml" instead of "test*.xml".
Placeholders are supported on the SFTP adapter since the correct syntax is used.
Not sure if it helps, give a try!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Stephen,
1. For files containing TEST in file name
.*TEST.* ( dot star TEST dot *) - .* is wild card entry in regex
2. the second requirement has to be handled with exclusion mask
in the exclusion mask type .*TEST.* and in the file name .*
follow these links for reference-
How to mask a file in SFTP adapter | SCN
Regards,
Vikas
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.