Increment a alphabet value to the next

lkganta · Post by **lkganta** » Mon Mar 15, 2010 1:32 pm

Hi,
I have the situation where I need to increment my input value as per below in the datastage 7.5 PX

INPUT
------

1234
44346
656566
44346
656566
44346
44346

OUTPUT
----------
1234
44346
656566
44346A
656566A
44346B
44346C

Here I am adding the alphabet to the number incase it comes again by incrementing the alphabet value.
Can you please help to increment the alphabet value? How to implement this logic ?

Thank you,

ray.wurlod · Post by **ray.wurlod** » Mon Mar 15, 2010 1:36 pm

Use a mix of Seq() and Char() functions in your stage variables.
Char(Seq(svPrevCharacter)+1) gives the next character, but what do you need to happen if the previous character is "Z"?

lkganta · Post by **lkganta** » Mon Mar 15, 2010 2:06 pm

Thank you very much for the reply. If the previous values reaches Z then I need to put the value "AA" and then increment it to AB,AC,AD...etc
It is kind of implementing the recursion concept correct?

Thank you,

ray.wurlod · Post by **ray.wurlod** » Mon Mar 15, 2010 6:42 pm

I have no idea - it's your business rule. I merely felt compelled to point out how important it was for you to consider it.

Kryt0n · Post by **Kryt0n** » Mon Mar 15, 2010 7:15 pm

Can be done via div and mod

Div giving the number of times you repeat the letter and mod to identify which letter