Trim the first characters

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
phanikumar
Participant
Posts: 60
Joined: Tue Sep 20, 2011 10:44 pm
Location: INDIA

Trim the first characters

Post by phanikumar »

Hi,

I need to trim the first few characters ina column

Ex:
i/p

109-87654567

o/p

87654567

I tried to use trim function it didn't worked.Can anyone post some ideas to acheive this.


Regards
kumar
Top
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
Contact ray.wurlod

Post by ray.wurlod »

Code: Select all

Right(InLink.TheColumn, Len(InLink.TheColumn) - 4)
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Top
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

You could also substring from position 5 to the end of the string.
-craig

"You can never have too many knives" -- Logan Nine Fingers
Top
phanikumar
Participant
Posts: 60
Joined: Tue Sep 20, 2011 10:44 pm
Location: INDIA

Post by phanikumar »

Thank you Ray That worked.

Regards
Kumar
Top
Post Reply

Return to “IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)”