tFTPFileList and Regular Expressions

[Anonymous]

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

Peter

[Anonymous]

Hello,

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?

Best regards

Sabrina

[Anonymous]

Hi Peter,

you can use below link to check whether your regular expression is correct or not .

www.debuggex.com

Also try with removing the .(dot) before the last bracket. use .* instead.

Let me know more about your issue.

Thanks,

Neha 

[Anonymous]

Sabrina,

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.

Peter

[Anonymous]

Hi,

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.

Best regards

Sabrina