How to insert empty lines in the field before and after a specific pattern?

[damucka]

Hello,

I have a column / field called LINE that consists of the several text lines.
I would like to format it a bit before I present it to the end users in the alert using $result.LINE$.
I have there the following header line:

****************************

and I would like to insert two empty lines before and one empty line below of it into the LINE field.

How would I do it?

Kind Regards,
Kamil

[richgalloway · Accepted solution]

Try rex.

... | rex field=LINE mode=sed "s/(\*{28})/\n\n\1\n/"

[efavreau]

Also, @damucka make sure you accept the answer.

[damucka]

Thank you.
This would do what I want. One more question, how would the sed for the following header line look like?
... I am struggling with it a bit in regex101

******************************* MEMORY *************************************

[richgalloway]

Try "s/(\*+ MEMORY \*+)/\nn\1\n/".

[efavreau]

It would be best if you let each question stand alone, as well as state what you tried. However, try this:
https://regex101.com/r/xPYiLc/1