REMOVEBLANKLINES – Remove blank lines from string

Overview

This Custom Field removes blanks lines and empty paragraphs from a given string. Only lines ending with a hard return are removed. Formattings tags are ignored. This function is useful for combining the contents of multiple fields and ensuring that empty paragraphs do not result from the concatenation.

Syntax

REMOVEBLANKLINES(String)

Example

Without removing blank lines, a concatenation of these fields would be:
CONCAT(FIELDSTR(‘Field A’),’^p’,FIELDSTR(‘Field B’),’^p’,FIELDSTR(‘Field C’))
This would result in an empty paragragh because Field B is empty:

Incorporating the REMOVEBLANKLINES Custom Field will remove any empty paragraphs:

See also

REMOVEDUPLICATES