I have derived column in the package (eight-bite integer value):
(Test_column % 1000000000).
we have a code 111100000001234566. Using this expression we received 1234566.
But now I need also fetch the first 4 digit and added this expression (Test_column % 1000000000).
So, I want to receive this value 11111234566.
Could you please help me to parse the value?