General

Re: A calculated value of a multiple-line field loses its line breaks

Patrick Halstead — Sun, 09 Feb 2014 20:38:16 GMT

I'm guessing it's because the multi-line list value only has a carriage return (or a line feed) whereas InfoPath requires both. I recommend using two translate functions. The inner translate will take the carriage return (CR) or linefeed (LF) and convert to a special value (say two asterisks - **). Then, the outer translate converts the asterisks to CRLF pair. To actually insert the CRLF pair, you will most likely have to add it to a secondary data source and refer to that field. Why? Well, you can't encode them in the fx dialog - at least I don't know how to do it.

There was a post last year about converting repeating values to linebreaks (CR LF) in a multi-line text field. Please search the forum for linebreak or CR-LF and it should show up.

Re: A calculated value of a multiple-line field loses its line breaks

york31 — Sat, 08 Feb 2014 18:23:24 GMT

Thx.

The original field was a multi-line field, plain text.

The calculated value box (in another form which imports the original field) is formatted as "Text" and I do not see a way to do define it any differently.

Following your advice, I changed the original field to rich text.

Now, in the other form the text I am getting is embedded in an xml expression.

Still not there...

Re: A calculated value of a multiple-line field loses its line breaks

Mel Clemente — Tue, 04 Feb 2014 09:15:21 GMT

Have you tried using a rich-text box or a multi-line text box?

A calculated value of a multiple-line field loses its line breaks

york31 — Sat, 01 Feb 2014 07:54:12 GMT

I am pulling data from a multiple-line field of another list into a caculated value display.

It works but the line breaks are lost.

Is there a way to force it to retain the line breaks?