Removing carriage returns from text

[baycolor]

Hi, I'm using CRV10.

My SQL is pulling data down from a comment field that has multiple strings of text separated by line feeds.

I need to work with the multiple strings in some CR formulas like it is one big string.

Currently any formulas I create stop looking at the comment field after the first line feed which is after the first string.

1)
Is there a way to remove all the line feeds from a field - could be 2 could be 25 - I never know?

2)
Is there a way to replace them with a pipe (as the line feeds are actually separating different info)?

 

[BobSuruncle]

You could turn on the "Can Grow" property in the Format Editor. This would show all of the lines.

If you really want to replace the line breaks, you could use the Replace function.
Depending on how your line break is entered, you could try this:

local stringvar br := chr(13)&chr(10);
replace({CustomerDemographics.CustomerDesc},br,"|")

Bob Suruncle