My input Test Data
--------------
P1 Y A
P2 Y C
P4 N D
P3 N C
P1 X B
P1 Y B
P5 N A

Condition: 1st to 3rd char and 6th character ascending order and 4 th char descending order.

Expected Output result
-----------------------

P1 Y A
P1 Y B
P2 Y C
P1 X B
P5 N A
P3 N C
P4 N D

Please help me it's very urgent.

Thanks for advance.

Thanks & Regards,
Viany Chada

Is this your homework? What have you done so far?

This is the requirement from one of our client's.

I created sample data to understand it better.... which was updated in my query.

Thanks,
Vinay

Your expected output does not match the problem description. What is it that you really need?

Anyway, the sort utility will certainly help you.

To get your expected output using your input
sort -k 2,2r -k 3,3 -k 1,1