question How to replace/add some text for a matching patter in Nifi in Support Questions

How to replace/add some text for a matching patter in Nifi

brajeshreddy — Fri, 21 Jul 2023 10:49:00 GMT

Hi,

Is there any processor to add some text/characters to each line in the flowfile in Nifi. Replace text seems to be more complicated given that the partiton value keeps changing.

compute incremental stats mydb.mytable partition (date=2023-07-21);

compute incremental stats mydb.mytable partition (name=abc);

compute incremental stats mydb.mytable partition (date='2023-07-21');

compute incremental stats mydb.mytable partition (name='abc');

Note: date=2023-07-21 comes as a complete string from the sys.partitions.part_name table in hive. We will need to add '' to the date.

Re: How to replace/add some text for a matching patter in Nifi

joseomjr — Sat, 16 Sep 2023 20:30:45 GMT

ReplaceText processor should work..

This RegEx search pattern should do the trick:

^(.*?)$([^=]*)=([^$]*)\);$

With this replacement value:

$1($2='$3')

Don't forget to set the evaluation mode to line-by-line...

Re: How to replace/add some text for a matching patter in Nifi

joseomjr — Mon, 18 Sep 2023 20:12:14 GMT

Forgot the ";" in the replacement value

$1($2='$3');