EXPLODE_RANGE

Syntax

EXPLODE_RANGE(<integer>;<integer>)
EXPLODE_RANGE(<string>;<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

Column2EXPLODE_RANGE() returns

1

51
732


3


4


5


7


6


5


4


3