Add a line break in a string

[IMSL]

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?

[binuacs]

@IMSL One way of doing this

[IMSL]

@binuacs 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?

[binuacs · Accepted solution]

@IMSL try the formula

[gawa]

hi @IMSL 

You can use Summarize tool to concat strings, and specify \n as a separator. Attaching WF for your reference. 

[Jayzonx]

Great solution @gawa. Thanks!