Field Comparision using SORT
Posted: Fri Dec 10, 2010 5:38 pm
I have a Fixed length File LRECL = 500. I want To perform field Comparision between 2 Records Appearing at Specific Position remaning all Fields are Same. Below is Example.
For Above Stated Examples Field Appearing at Col. 14 Only Differs Other fields are same. Comparision has to be Perform Bwteen Rec A & Rec B & O/P File Should have Rec A. Similarly Comparision has to be Perform Bwteen Rec C & Rec D & O/P File Should have Rec D.
O/P File Should have Records
ABCD|1234XYZ|77|2010-12-12|HELLO
ABCD|9999XYZ|22|2010-12-18|HELLO
Thanks
Kind Rgds.
ABCD|1234XYZ|77|2010-12-12|HELLO --> Rec A
ABCD|1234XYZ|00|2010-12-12|HELLO --> Rec B
ABCD|9999XYZ|11|2010-12-18|HELLO --> Rec C
ABCD|9999XYZ|22|2010-12-18|HELLO --> Rec D
ABCD|1234XYZ|00|2010-12-12|HELLO --> Rec B
ABCD|9999XYZ|11|2010-12-18|HELLO --> Rec C
ABCD|9999XYZ|22|2010-12-18|HELLO --> Rec D
For Above Stated Examples Field Appearing at Col. 14 Only Differs Other fields are same. Comparision has to be Perform Bwteen Rec A & Rec B & O/P File Should have Rec A. Similarly Comparision has to be Perform Bwteen Rec C & Rec D & O/P File Should have Rec D.
O/P File Should have Records
ABCD|1234XYZ|77|2010-12-12|HELLO
ABCD|9999XYZ|22|2010-12-18|HELLO
Thanks
Kind Rgds.