REPEAT( ) function
Returns a string that repeats a substring a specified number of times.
Syntax
REPEAT(string, count)
Parameters
Name | Type | Description |
---|---|---|
string | character | The string to repeat. |
count | numeric | The number of times to repeat the value of string. |
Output
Character.
Examples
Basic examples
Returns "ABCABCABC":
REPEAT("ABC",3)
Returns "000000000":
REPEAT("0",9)
Remarks
When to use REPEAT( )
Use the REPEAT( ) function to initialize a variable with constant values or blanks, or to set a default value for a computed field.