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.