Difference between revisions of "Exporting Multiple Lines Text Fields to HTML"
From SmartWiki
| Line 1: | Line 1: | ||
If you wish to include a [[Multiple Lines Text]] field in a report that will be displayed or exported to HTML, the line breaks will not be displayed. | If you wish to include a [[Multiple Lines Text]] field in a report that will be displayed or exported to HTML, the line breaks will not be displayed. | ||
| − | The line breaks stored in the [[Multiple Lines Text]] field can be converted to a line break that will be displayed in HTML ('''<br />''') by including the following in the '''[[Calculated | + | The line breaks stored in the [[Multiple Lines Text]] field can be converted to a line break that will be displayed in HTML ('''<br />''') by including the following in the '''[[Calculated Value|Calculated Value]]''' of the field: |
REPLACE([this],CHAR(13,10),"<br />") | REPLACE([this],CHAR(13,10),"<br />") | ||
[[Category:Reports]] | [[Category:Reports]] | ||
Latest revision as of 07:43, 11 July 2013
If you wish to include a Multiple Lines Text field in a report that will be displayed or exported to HTML, the line breaks will not be displayed.
The line breaks stored in the Multiple Lines Text field can be converted to a line break that will be displayed in HTML (<br />) by including the following in the Calculated Value of the field:
REPLACE([this],CHAR(13,10),"<br />")
