Hi, I have a question on sorting and merging two files. I have two files with the following data
File A
******
File A
******
aaaa 5 aaaa aaa 888 aaa
gggg 5 gggg ggg 555 ggg
bbbb 5 bbbb bbb 444 bbb
rrrr 5 rrrr rrr 999 rrr
File B
******
tttt 10 tttt ttt 444 ttt
yyyy 10 yyyy yyy 666 yyy
ffff 10 ffff fff 111 fff
kkkk 10 kkkk kkk 999 kkk
cccc 10 cccc ccc 444 ccc
zzzz 10 zzzz zzz 234 zzz
vvvv 10 vvvv vvv 888 vvv
I need the out put in the following format
bbbb 5 bbbb bbb 444 bbb
tttt 10 tttt ttt 444 ttt
cccc 10 cccc ccc 444 ccc
gggg 5 gggg ggg 555 ggg
aaaa 5 aaaa aaa 888 aaa
vvvv 10 vvvv vvv 888 vvv
rrrr 5 rrrr rrr 999 rrr
kkkk 10 kkkk kkk 999 kkk
yyyy 10 yyyy yyy 666 yyy
ffff 10 ffff fff 111 fff
zzzz 10 zzzz zzz 234 zzz
merge Files A & B by groupin on the feild 5 and sort the feild 2 so that the number 5 (from file A) in the feild comes first and number 10 (from the files B) comes next.
Please let me know if any one has ideas.
Thank you so much in advance
Srini
