Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Get files using ListFile but filtering by its name that has a date inside it

Solved Go to solution
Highlighted

Get files using ListFile but filtering by its name that has a date inside it

New Contributor

Hello everyone, please help!

I have files whose name is formed by a date in the format "yymmdd", for example:


TRB_ASE_D190125.txt

TRB_TIT_D190125.txt


I need to get only the files whose names match the current date. For example, if the date was "190125", the 2 subsequent files would match that criterion.

I am using the ListFile processor to get the files and put this regular expression using the "now" function in the File Filter, but it does not work:


^TRB_[A-Z]+_D${now():format('yymmdd')}.TXT


Thanks in advance!

1 ACCEPTED SOLUTION

Accepted Solutions

Re: Get files using ListFile but filtering by its name that has a date inside it

Master Guru

@Mario Tigua

The File Filter property in the listFile processor does not support NiFi Expression Language. If yo float your cursor of the question mark icon to the right of a property name it will display a pop-up window that will tell you if this property will support NiFi expression language.
-

This property expects a java regular expression instead.

-

Thank you,

Matt

-

If you found this answer addressed your question, please take a moment to login in and click the "ACCEPT" link.

1 REPLY 1

Re: Get files using ListFile but filtering by its name that has a date inside it

Master Guru

@Mario Tigua

The File Filter property in the listFile processor does not support NiFi Expression Language. If yo float your cursor of the question mark icon to the right of a property name it will display a pop-up window that will tell you if this property will support NiFi expression language.
-

This property expects a java regular expression instead.

-

Thank you,

Matt

-

If you found this answer addressed your question, please take a moment to login in and click the "ACCEPT" link.

Don't have an account?
Coming from Hortonworks? Activate your account here