question Re: NIFI - Extract data from flowfile to write a Query in Support Questions

NIFI - Extract data from flowfile to write a Query

Alexandros — Sun, 19 Jan 2020 02:36:22 GMT

Hi, I have a flowfile with this format:

I need to write a query with the parameters, so I need to extract the numbers, with this for example:

(\d{2}.\d{4})

And put the 2 resultos in:

Insert into table(a,b) VALUES($1,$2)

How can I do this?

Thanks!

I tryed with replaceText but it's not what im looking for

Re: NIFI - Extract data from flowfile to write a Query

DennisJaheruddi — Mon, 20 Jan 2020 18:01:35 GMT

The first thing that comes to mind is the Extract Text processor. It allows you to get (multiple) parts from the text and put it into attributes.

org.apache.nifi.processors.standard.ExtractText

Re: NIFI - Extract data from flowfile to write a Query

MattWho — Wed, 22 Jan 2020 21:59:13 GMT

@Alexandros

You can accomplish this use ReplaceText with a more complex Java regular expression.

The Replace Text is designed to replace every occurrence of the string matched by your java regular expression with the replacement value. So you are probably seeing your replacement value inserted into your existing content twice.

Try using the following java regular expression which will match your entire 3 lines of content:

.*\n.*?(\d{2}.\d{4}).*?\n.*?(\d{2}.\d{4}).*

Leave your replacement value as you already have it and make sure you have Evaluation mode still set to Entire text.

Hope this helps,

Matt