Replace carriage return with Text

[stefanshotton]

I have some calc fields that are being exported to an rft file with coding to format the new document ie bold, font size etc embedded in the calc.

have worked out that to get a new line you have to have line in the code rather than a carriage return symbol.

problem is that some of the fields are user entered paragraphs with line spaces in.

is there a way to change a line space in a text field into line ?

Thought about using the substitute but not sure how.

Please post if you dont thinks its possible so I dont waste too much time working on it!

Thanks

[stefanshotton]

Figured it out

substitute(Text; "¶"; "line")

Even though the carriage return symbol is not in the text its just a line space this still works.