View previous topic :: View next topic
|
Author |
Message |
jainsunilkansal
New User
Joined: 21 Nov 2013 Posts: 3 Location: India
|
|
|
|
Hi,
Could you please help with the below Sort criteria.
Merge two files into a single file with header,detail and trailer and update the trailer totals.
File1 : Header1,Detail1 ,Trailer1
------------------------------------------------------
Code: |
020121217 >>>>>>>>>>>>>HEader 1
1 00000000006655075 %
2 % Ãí *
3 % Ãí *
3 % Ãí *
1 00000005994793512 ñ
2 rålé ã* ñ
3 rålé ã* ñ
3 rålé ã* ñ
3 rålé ã* ñ
3 rålé ã* ñ
1 00000005996934809 h@
2 rÑ Øæ ã* h@
3 rÑ Øæ ã* h@
3 rÑ Øæ ã* h@
3 rÑ Øæ ã* h@
900000003 >>>>>>>>TRAILER 1 (Number of customer total of 1's in first column) |
File2 : Header2,Detail2 ,Trailer2
Same as above.
Output :
File3 : Header1,Detail1,Detail2,Trailer3
Code: |
020121217 >>>>>>>>>>>>>HEader 1
1 00000000006655075 %
2 % Ãí *
3 % Ãí *
3 % Ãí *
1 00000005994793512 ñ
2 rålé ã* ñ
3 rålé ã* ñ
3 rålé ã* ñ
3 rålé ã* ñ
3 rålé ã* ñ
1 00000005996934809 h@
2 rÑ Øæ ã* h@
3 rÑ Øæ ã* h@
3 rÑ Øæ ã* h@
3 rÑ Øæ ã* h@
1 00000000006655075 %
2 % Ãí *
3 % Ãí *
3 % Ãí *
1 00000005994793512 ñ
2 rålé ã* ñ
3 rålé ã* ñ
3 rålé ã* ñ
3 rålé ã* ñ
3 rålé ã* ñ
1 00000005996934809 h@
2 rÑ Øæ ã* h@
3 rÑ Øæ ã* h@
3 rÑ Øæ ã* h@
3 rÑ Øæ ã* h@
900000006 >>>>>>>>TRAILER 1 (Number of customer total of 1's in first column) |
Can any one suggest a much easier solution to the above sort.
please tell me if some one need some more info
Code'd |
|
Back to top |
|
|
Bill Woodger
Moderator Emeritus
Joined: 09 Mar 2011 Posts: 7309 Location: Inside the Matrix
|
|
|
|
Much easier than what? If you already have something, please show it. If you don't, why not?
Also we need to see the expected output from the sample input you have shown, and a description of what goes on.
Please use the Code tags:
Code: |
Like This. To preserver Spacing. |
|
|
Back to top |
|
|
jainsunilkansal
New User
Joined: 21 Nov 2013 Posts: 3 Location: India
|
|
|
|
I given output file as well that is sample output .
Output :
File3 : Header1,Detail1,Detail2,Trailer3
Code: |
020121217 >>>>>>>>>>>>>HEader 1
1 00000000006655075 %
2 % Ãí *
3 % Ãí *
3 % Ãí *
1 00000005994793512 ñ
2 rålé ã* ñ
3 rålé ã* ñ
3 rålé ã* ñ
3 rålé ã* ñ
3 rålé ã* ñ
1 00000005996934809 h@
2 rÑ Øæ ã* h@
3 rÑ Øæ ã* h@
3 rÑ Øæ ã* h@
3 rÑ Øæ ã* h@
1 00000000006655075 %
2 % Ãí *
3 % Ãí *
3 % Ãí *
1 00000005994793512 ñ
2 rålé ã* ñ
3 rålé ã* ñ
3 rålé ã* ñ
3 rålé ã* ñ
3 rålé ã* ñ
1 00000005996934809 h@
2 rÑ Øæ ã* h@
3 rÑ Øæ ã* h@
3 rÑ Øæ ã* h@
3 rÑ Øæ ã* h@
900000006 >>>>>>>>TRAILER 1 (Number of customer total of 1's in first column) |
Code'd |
|
Back to top |
|
|
expat
Global Moderator
Joined: 14 Mar 2007 Posts: 8797 Location: Welsh Wales
|
|
|
|
Use the CODE tags
Code: |
[code] Put what you want in here [/code] |
|
|
Back to top |
|
|
jainsunilkansal
New User
Joined: 21 Nov 2013 Posts: 3 Location: India
|
|
|
|
Waiting for the post's..if anyone knows solutions please advice |
|
Back to top |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007 Posts: 10872 Location: italy
|
|
|
|
soliciting for answers after only 3 hours from the initial post is inconsiderate
remember, replying on a forum is ...
on voluntary base
on our own time
if You have time constraint a forum is not the best place to ask for help |
|
Back to top |
|
|
|