The Repeat function returns the results of repeating a string a specified number of times.

Repeat is one of the Text functions supported by Sigma.

Syntax

Repeat(string, number)

Repeat has the following arguments:

string
Required
The string that the function repeats
number
Required
The number of times the string repeats.
The zero, 0, and negative values both return a NULL string.

Examples

Repeat([Product Type],0)
Repeat([Product Type],1)
Repeat([Product Type],2)
Repeat([Product Type],3)
Repeat([Product Type],-1)

The Repeat function returns the following values for the Product Type column:


Related resources