Exporting Multiple Lines Text Fields to HTML

From SmartWiki
Revision as of 12:02, 24 March 2013 by Cameron (talk | contribs) (Created page with ' 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 t…')

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

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),"
")