Turn Text into Attributes

[#1]

Hi everyone,

I use NiFi to frequently check if a website is up or down. I get the following response as text in a single Flowfile:

HTTP/1.1: 200 Connection established
Proxy-Agent: Fortinet-Proxy/1.0
Content-Type: image/jpeg
Connection: keep-alive
Date: Tue, 12 Sep 2023 14:05:43 GMT
Server: Apache
Strict-Transport-Security: max-age=31536000
URL: https://test.com

 How can I turn these lines into Key/Value-Pairs or Attributes, to use them with further processors? My goal is to save these Informations in an mySQL Database where the following fields are given:

• HTTP/1.1
• Proxy-Agent
• Content-Type
• Connection
• Date
• ...

Best regards

Maik

[#2 · Accepted solution]

Hi @CommanderLaus ,

The easiest way I can think of is to use the ExtractText Processor where you define an attribute as dynamic property and assign the Regex as follows:

I did only the first three fields but you can do the others the same way.

If that helps please accept solution.

Thanks

[#3]

Hi @SAMSAL ,

that's pretty simple, but works fine for me. Thanks for the advice.

Regards
Maik