HCL Domino - @Explode - Need a Domino Consultant? Call NotesMail +1 212-599-2048

HCLSoftware Business Partner Domino Consulting Services CRUCIAL Notes Tools +1 212-599-2048	Domino Consulting Services CRUCIAL Notes Tools Domino administration Notes development	Chat now
.

Need a Domino Consultant? Call NotesMail +1 212-599-2048 - HCLSoftware Business Partner

FORMULA LANGUAGE

@Explode
Example

Returns a text list composed of the elements of a text string or date range.

If you specify a text string, elements are defined as sequences of characters separated by separator characters and newlines.
If you specify a time-date range, elements are defined as individual days within the range.

Syntax

@Explode( dateRange )
@Explode( string )
@Explode( string ; separators )
@Explode( string ; separators ; includeEmpties )
@Explode( string ; separators ; includeEmpties ; newlineAsSeparator )

Parameters

dateRange

Time-date range or time-date range list. The range of dates that you want to make into a text list. Specify a valid date-time range, not a string representation of one. For example, @Explode( "05/01/96 - 05/02/96" ) is invalid because the parameter is a string. Use @Explode( [05/01/96 - 05/02/96] ).

string

Text or text list. The string that you want to make into a text list.

separators

Text. Optional. One or more characters that define the end of an element in

string

. The default separators are " ,;" (space, comma, semicolon), which means that Lotus Domino adds a new element to the text list each time a space, comma, or semicolon occurs in the original string

When you use more than one character to specify separators, each character defines one separator. For example, the specification "and" breaks the string at each occurrence of "a," "n," and "d"; it does not break the string at each occurrence of the word "and." The newline is a separator, regardless of the specification of this parameter, unless

newlineAsSeparator

is specified as False.

includeEmpties

Boolean. Optional. Specify True (1) to place an empty string ("") in the returned list when a separator

appears at the beginning or end of the string

or two separators appear consecutively in the string

Specify False (0) to not include empty list elements for leading, trailing, and consecutive separators. Defaults to False.

newlineAsSeparator

Note This parameter is new with Release 6.

Boolean. Optional. Specify True (1) to treat the newline as a separator

Specify False (0) to not treat the newline as a separator. Defaults to True.

Return value