Repeats a string value.
|string||An expression that resolves to a string or number.|
|repeats||An expression that resolves to a positive integer specifying the number of repeats.|
The STR function replicates and concatenates a string multiple times. The number of repetitions 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, STR returns a null string.
You can use the STRS function to perform the same operation on all of the elements of a dynamic array.
The following example uses the STR function to repeat a string: