topic Re: tFTPFileList and Regular Expressions in Talend Studio

tFTPFileList and Regular Expressions

Anonymous — Sat, 16 Nov 2024 08:53:08 GMT

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

Re: tFTPFileList and Regular Expressions

Anonymous — Wed, 10 Jan 2018 08:38:41 GMT

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

Re: tFTPFileList and Regular Expressions

Anonymous — Wed, 10 Jan 2018 09:12:32 GMT

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

Re: tFTPFileList and Regular Expressions

Anonymous — Wed, 10 Jan 2018 12:56:11 GMT

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

Re: tFTPFileList and Regular Expressions

Anonymous — Thu, 11 Jan 2018 03:46:53 GMT

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