Hi All
I just want to know one small transformation like
I have the value "A12345" as src value
and it should be populated as "12345" in the target
ie the first char should be truncated and populated to the target
the job is parallel job
src:table/file
tgt:table
truncate the first char
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 57
- Joined: Sat Jun 09, 2007 1:14 am
- Location: chicago
truncate the first char
Hi I have experience in parallel extender datastage I am ready to give/take help from other
hope we all help each other hand in hand
hope we all help each other hand in hand
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Code: Select all
Right(InLink.TheString, Len(InLink.TheString) - 1)
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.