Difference between revisions of "Exporting Multiple Lines Text Fields to HTML"
From SmartWiki
| Line 2: | Line 2: | ||
The line breaks stored in the [[Multiple Lines Text]] field can be converted to a break that will be displayed in HTML (<br />) by including the following in the '''Calculated Value''' of the field: | The line breaks stored in the [[Multiple Lines Text]] field can be converted to a break that will be displayed in HTML (<br />) by including the following in the '''Calculated Value''' of the field: | ||
| − | REPLACE([this],CHAR(13,10)," | + | REPLACE([this],CHAR(13,10),"<br />") |
[[Category:Reports]] | [[Category:Reports]] | ||
Revision as of 11:04, 24 March 2013
If you with to include a Multiple Lines Text field in a report this 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 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 />")
