View previous topic :: View next topic
|
Author |
Message |
sakrat
Active User
Joined: 05 Feb 2014 Posts: 164 Location: India
|
|
|
|
Hi everyone,
Here is my requirement below:
Input file:
Code: |
abc~01/04/2014~0000000001~0000000000001021.21~01/04/2014~aaaa~0000000002~0000000000000023.34
abc~01/03/2014~0000000020~0000000000000104.34~01/03/2014~aaaa~0000000023~0000000000000045.00
def~04/05/2016~0000000010~0000000000000239.00~04/05/2016~bbbb~0000000012~0000000000000012.11
def~03/02/2016~0000000019~0000000000000002.12~03/02/2016~bbbb~0000000018~0000000000000005.11 |
Then I want my output file as below:
Code: |
abc~01/04/2014~0000000021~000000000001125.55~01/04/2014~aaaa~0000000025~000000000000068.34
def~04/05/2016~0000000029~000000000000241.12~04/05/2016~bbbb~0000000030~000000000000017.22 |
I tried with TOT in the TRAILER, then tried with IF THEN & BUILD but no luck I couldn't get clear idea of how do arrive at the resulting so that i can get this output file.
Can someone please help me with this...
Thanks,
CODED-please use Code tags while posting code/sample data |
|
Back to top |
|
|
dneufarth
Active User
Joined: 27 Apr 2005 Posts: 419 Location: Inside the SPEW (Southwest Ohio, USA)
|
|
Back to top |
|
|
Arun Raj
Moderator
Joined: 17 Oct 2006 Posts: 2481 Location: @my desk
|
|
|
|
sakrat wrote: |
I tried with TOT in the TRAILER, then tried with IF THEN & BUILD but no luck |
Can you show what you tried? |
|
Back to top |
|
|
|