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.
Watch the recorded webinar!
Pick up some tips and tricks with Context Variables
Learn how media organizations have achieved success with Data Integration
Introduction to Talend Open Studio for Data Integration.