Repeats the string value of each element of a dynamic array.
The
STRS function replicates each element of a dynamic array the number of times specified by
repeats. In the returned dynamic array the value of each element of
dynarray is replicated and concatenated the same number of times. The number of replications is specified by the
repeats argument.
The
repeats argument specifies the number of repeats as a positive integer. If
repeats is a decimal number, it is truncated to an integer. The
repeats string is parsed as an integer until a non-numeric character is encountered. Thus 7dwarves is parsed as 7. If
repeats is 0, a negative number, or a non-numeric string,
STRS returns a null string for all elements.
The following example uses the
STRS function to triplicate the value of each element of a dynamic array. Note that the third element is a null string: