Filtering records from a file using NiFi.

[#1]

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!

[#2 · Accepted solution]

@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.

[#3]

Thanks Meyer!!!