Method: Coalesce( … )

Returns the first part that has a value.
This method is very useful if, e.g. you would like to use the value from one field as the primary source, but have 1 or more backup-fields in case the primary or secondary fields are empty.

Syntax

string Coalesce ( params string[] parts )

Example

// If Input-row Text1-column does not have a value, then the value from Text2-column will be used, unless this is also blank, then Text3-columns etc.

Value = Coalesce( "{Text1}", "{Text2}", "{Text3}" );

// parts contained in brackets {} will be looked up in Input-row

1 Syntax
2 Example