Trying to use regular expressions (RE) with the tFTPFileList component.
The RE is ^((?!BAMTiming30D|BAMCensus).)*.csv
If I just use a file mask of *.csv all of the csv files are listed.
I know the RE is correct because I use it with tFileList and I get the proper list of files.
Reading the documentation for tFTPFileList is says:
Filemask: enter the filename or filemask using wildcharacters (*) or regular expressions.
So RE is supported, but I cannot get it to work.
Using 6.4.1 Enterprise.
Thank for the help
Is there any error Info printed on console when you use regular expressions (RE) ^((?!BAMTiming30D|BAMCensus).)*.csv in tFTPFileList? Do you get same result by using tFTPGet?
you can use below link to check whether your regular expression is correct or not .
Also try with removing the .(dot) before the last bracket. use .* instead.
Let me know more about your issue.
I doubled checked my RE and it is correct.
If you review the tFTPGet component there is a check box in order to select Perl 5 Regex as filemask.
No such checkbox exists for the tFTPFileList component, even though the documentation states that tFTPFileList supports Regex.
I have worked around the issue for now by adding a tJavaRow component after the tFTPFileList component to apply the appropriate Regex.
It works perfect fine when you use tFTPGet component with Perl 5 Regex option checked?
We suppose that the regular expression does not work with Glob Expressions.
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Part 2 of a series on Context Variables
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema