Urgent

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
kunal1101
Participant
Posts: 8
Joined: Mon Dec 03, 2007 11:50 pm
Location: Pune

Urgent

Post by kunal1101 »

Hi,
I have data coming in following format:-
1000,
1000,5
1000,52
where ',' denotes decimal...
i want op in following format:-
0000000000000000100000
0000000000000000100050
0000000000000000100052
i.e THE SEPRATOR ',' should be removed and the amt field should be appended by zeroes(i.e if length before ',' is 4 12 zeroes should be appended,if it is 5,11 zeroes should be appened and so on...)
Kunal_devil!!!
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

We don't do URGENT here. DSXchange is an all-volunteer site whose participants post as and when they can. If you want urgent help, sign up with your support provider for premium service, and learn how much "urgent" is worth.

Further, URGENT is not a particularly meaningful subject. You should always try to create a subject that will assist future searchers.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
jvmerc
Participant
Posts: 94
Joined: Tue Dec 02, 2003 12:57 pm

Post by jvmerc »

You need to define you elements in your type tree. Go thru the properties of your element and define it based on your requirements. The second part of your needs is easy. right justify, zero fill, no separators.
Post Reply