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,
Increment a alphabet value to the next
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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"?
Char(Seq(svPrevCharacter)+1) gives the next character, but what do you need to happen if the previous character is "Z"?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: