anilaics
New User
Joined: 15 Feb 2006 Posts: 1
|
|
|
|
Please clarify below doubt in using sort utility
Input1
B052RRN.RASRSC.ASSOC11.EXT3
11aaaaaa111112
77gggggg777777
44dddddd444445
55eeeeee555555
22bbbbbb222223
66ffffff666666
88hhhhhh888888
33cccccc333333
Input2
B052RRN.RASRSC.ASSOC11.EXT2
11aaaaaa111111
77gggggg777777
44dddddd444444
55eeeeee555555
22bbbbbb222222
66ffffff666666
88hhhhhh888888
33cccccc333333
sort card used
JOINKEYS FILES=F1,FIELDS=(1,2,A,9,6,A)
JOINKEYS FILES=F2,FIELDS=(1,2,A,9,6,A)
JOIN UNPAIRED,F1,ONLY
REFORMAT FIELDS=(F1:9,6,F1:1,2)
SORT FIELDS=COPY
Output getting
11111211......
22222322......
44444544......
Expected output(what should be changed in sort card to get the below o/p)
Layout
1-6 bytes=fields mimatch from file
7-8 bytes=1st 2 bytes from file1
9-14bytes=fields from file2 having mismatch
11111211111111
22222322222222
44444544333333 |
|