How to code for trimming variable length of text

Formally known as "Mercator Inside Integrator 6.7", DataStage TX enables high-volume, complex transactions without the need for additional coding.

Moderators: chulett, rschirm

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

Post by ray.wurlod »

What the OP really wants, vamsi.4a6, is a WebSphere TX map. This is NOT a requirement for a DataStage solution. That's why it's in the TX forum.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
siva9880
Participant
Posts: 12
Joined: Wed Apr 02, 2008 3:13 am

Post by siva9880 »

Please help me in WTX8.3
vamsi.4a6
Participant
Posts: 334
Joined: Sun Jan 22, 2012 7:06 am
Contact:

Post by vamsi.4a6 »

@ray.wurlod

Sorry Ray I have not check it properly
siva9880
Participant
Posts: 12
Joined: Wed Apr 02, 2008 3:13 am

Post by siva9880 »

Got the solution by my own.

solution for this case is
=TRIMRIGHT(input, WORD(input, RIGHT( LEAVENUM(input),1), -1))

Thanks,
siva9880
Post Reply