Shift one byte to right

consulting · Post by **consulting** » Fri Dec 05, 2008 12:06 pm

Hi
My reqriment is at present i am having 24 byte column with 24 zero
(000000000000000000000000) like this after doing calculation i have to put the calculated value in the first byte and to truncate the last 0.

like this if i run the job every month the last byte should be truncate and new value will be printed in the first byte

chulett · Post by **chulett** » Fri Dec 05, 2008 12:16 pm

And the 'calculated value' will always be a single digit?

consulting · Post by **consulting** » Fri Dec 05, 2008 12:20 pm

kandyshandy · Post by **kandyshandy** » Fri Dec 05, 2008 12:21 pm

For e.g. If your column name is Z,

CalculatedValue : Z[1,23]

chulett · Post by **chulett** » Fri Dec 05, 2008 12:33 pm

Or if the length of the target is variable:

Code: Select all

CalculatedValue : Left(InLink.Z, Len(InLink.Z) - 1)

consulting · Post by **consulting** » Fri Dec 05, 2008 12:39 pm

another reqriment is i have to count in first 6 byte there are how many value greater than 1

ray.wurlod · Post by **ray.wurlod** » Fri Dec 05, 2008 3:13 pm

Hey, come on. That is totally not the original question. Have you wasted our time here? It's a new question: please begin a new thread for it.