Syntax
EXPLODE_RANGE(<integer>;<integer>)
EXPLODE_RANGE(<sting>;<string>)
Description
Explodes a integer or IP address range into multiple rows. An IP address range is first converted to a range of integers. The range length is limited to 100000. All arguments must be of the same type.
Example
Column1 | Column2 | EXPLODE_RANGE() returns |
|---|---|---|
1 | 5 | 1 |
| 7 | 3 | 2 |
| 3 | ||
| 4 | ||
| 5 | ||
| 7 | ||
| 6 | ||
| 5 | ||
| 4 | ||
| 3 |