Links

range

To return an array of consecutive numbers
With this function, you can define a numeric value range with a from-to specification. Where from might be set automatically to 0 if there is only one parameter.
The from value is included and the to value is excluded.

Syntax

range(number)
range(number, number)
range(number, number, number)

Return

[number]

Examples

range(to) To return an array of consecutive numbers starting with 0 up or down to to, where to is excluded.
concat(range(7))
Result: 0, 1, 2, 3, 4, 5, 6
range(from, to) To return an array of consecutive numbers from a range between from and to, where from is included and to is excluded. If from is higher than to the numbers will appear in reverse order.
range(2,7)
Result: [2, 3, 4, 5, 6]
range(from, to, step) To return an array of consecutive numbers from a range between from and to by a given step, where from is included and to is excluded. If from is higher than to the numbers will appear in reverse order.
range(2, 9, 2)
Result: [2, 4, 6, 8]

See also

concat, which returns all items of an array in one string.
Last modified 1yr ago