Add a line break in a string

Hi everyone,

I have a field with a value like this:

"here is an example for line 1 *| here is an example for line 2"

I need to use the "*|" as a sign to break the text in to a new line within the same record. Like this:

"here is an example for line 1

here is an example for line 2"

Can anyone help me with this?

Help

Accepted answers

@IMSL try the formula

@IMSL One way of doing this

@binu_acs Thanks for your reply. As I mentioned in my question, I want the results be in one record not in two records as in your solution.

Could you help me with that?

@IMSL try the formula