Split values in loadscript

[#1]

In my loadscript  i want to load the first digits to one value and the rest to another.

123456789000 should become

123456 (value 1)

789000 (value 2)

I've a fixed limit should always be the first 6 didigts to value 1 and the last to value 2

[#2]

left(value,6) as value1,

right(value,6) as value2

[#3]

Ok so in Load script it should be if my table are named "Order_number"

Order_number left(value,6) as value1,

Order_numver right(value,6) as value2,

or is it

left(order_number,6) as value1,

right(order_number,6) as value2,

?

[#4]

load left(order_number,6) as value1,

right(order_number,6) as value2

[MK_QSL]

Left(Order_number,6) as Value1,

Right(Order_number,6) as Value2