Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
left(value,6) as value1,
right(value,6) as value2
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,
?
load left(order_number,6) as value1,
right(order_number,6) as value2
Left(Order_number,6) as Value1,
Right(Order_number,6) as Value2