question Re: Filtering records from a file using NiFi. in Support Questions

Filtering records from a file using NiFi.

rohit_ravishank — Sun, 02 Apr 2017 16:32:07 GMT

Hi Team,

In my file I have some records as show below,

Sample

Input-

1|transaction|I|2017-03-28|Current

1|master|B|2017-03-28|Current

1|master|A|2017-03-28|Current

Required Output-

1|transaction|I|2017-03-28|Current

1|master|A|2017-03-28|Current

While processing the file using NiFi, I want to consider only records having "I" & "A" in the third position.

I am trying to use "RouteText" processor using regular expression to filter the records. However I am not successful in getting the correct expression for filtering the records.

Could you please help me out?

Thanks!

Re: Filtering records from a file using NiFi.

jmeyer — Sun, 18 Aug 2019 08:35:08 GMT

@Rohit Ravishankar

You should be able to do this with RouteText. I suspect the configurations/regex you currently have may need some updating to get the functionality your looking for. Below is a screen should of something that should work. I also created a small example here.

Re: Filtering records from a file using NiFi.

rohit_ravishank — Mon, 03 Apr 2017 07:22:36 GMT

Thanks Meyer!!!