Originally posted by: maddysam

Team , I have a scenario to sort the data based on 3rd and 4th fields from the record.

Input as below,

ca|ab|zz|sz|ab
aa|ab|cd|ef|gh
zz|34|12|aa|67
zz|34|55|11|67

Step1 - I have re-ordered the data so that 3rd and 4th fields now will be 1st and 2nd and the output1 now looks like below,

zz|sz|ca|ab|ab
cd|ef|aa|ab|gh
12|aa|zz|34|67
55|11|zz|34|67

Step2 - I have used fmap(sortup(1stoutputcard)) in output2 to sort the data and the final output is as below,

zz|34|12|aa|67
zz|34|55|11|67
aa|ab|cd|ef|gh
ca|ab|zz|sz|ab

Hope I missed some logic , so it is sorting the data based on only 3rd field but not combination of 3rd and 4th , because the output should appear as follows,

zz|34|55|11|67
zz|34|12|aa|67
aa|ab|cd|ef|gh
ca|ab|zz|sz|ab

Could some one help me out on this.

Cheers,

Maddy

Originally posted by: maddysam

Can some one please provide a possible suggestion/solution..

Thanks,

Maddy

Originally posted by: prap

Hi,

The sort is based on the ASCI comparison & it traverses from left most character to r8 so the output is intact. I guess, you are not trying to sort out based on the 4 field instead of 3rd. if possible, can you please elaborate more on this.