[resolved] tFilterRow Advanced Mode Regex match fails?

[Anonymous]

Hi All,
I have a simple job that iterates through a directory of files. I am seeking to filter the files where the name matches a list of regular expressions. I want to report on those files that match, and those that dont. (Those that match will continue for further processing).
I have:
tFileList -> tFileProperties -> tFilterRow - tLogRow (filter)
|
------- tLogRow (reject)
In the configuration of the tFilterRow, I have specified "advanced mode" and used the statement:
input_row.basename.matches("^\\d+")
as my initial test is simply to identify files beginning with any sequence of digits.
Currently all rows route through the reject log.
I have tested the same regex statement with tExtractRegexFields and it worked.
Does tFilterRow NOT support regex in this way?
Thanks

[_AnonymousUser]

Hi sanvaibhav,
I used the open source version of talend, I can't use tMemorize.
Have you another solution please. My issue is how I read a line and the next line in the same time?
I'm beginner in talend.
Tahnks.

[Anonymous · Accepted solution]

Hi souha,
tMemorizeRows component is from Talend Open Studio for data integration and not from paid / enterprise ...
Which version of talend you are using?
Another way could be to save the value of respective column to some context variable and then checking that value with the current row... after checking the value, at the end again save current value to context variable...
Vaibhav

[_AnonymousUser]

Hi sanvaibhav
I upgraded into Talend 5.4 and I finally get tMemorize, but I have a bad question: TMemorize allow me to memorize the previous lines but I would like to memorize the nextLine of the current one.
I don't know if it's feasible or no?
Thanks.

[Anonymous]

Hmm... that's tricky... you can do it
Vaibhav