'The information in the cell orderdata = 3;890;ID117;K¤¤3;890;ID117;K¤¤3;890;ID117;K¤¤3;890;ID117;K

'The information in lines (obviously lol): 3;890;ID117;K

orderdata = rs("orderdata")

Dim productArray(), i

i = 0

lines = split(orderdata,"¤¤")

For Each x In lines
	arrayTemp = split(x, ";")
        prodLength = UBound(productarray)

	redim productarray(UBound(arrayTmp) + prodLength)
	productArray(i) = arrayTemp(0)
	i = i + 1
Next