Dear experts,
I'm newbie to awk scripting. Need your great help to convert the irregular lines into column using awk in windows2003 server environment. (Sorting based on "Pri Number" column)
Input files is as follows:
Partition Name: OA
Partition UID: 88:93:22:AE:B3:42:DF:11:A8:64:00:60:16:36:04:02
HBA/SP Pairs:
HBA UID SP Name SPPort
------- ------- ------
50:01:43:80:04:C4:28:81:50:01:43:80:04:C4:28:80 SP A 0
Host name: OA_02
50:01:43:80:04:C4:28:81:50:01:43:80:04:C4:28:80 SP B 1
Host name: OA_02
50:01:43:80:04:C4:28:83:50:01:43:80:04:C4:28:82 SP B 0
Host name: OA_02
50:01:43:80:04:C4:28:83:50:01:43:80:04:C4:28:82 SP A 1
Host name: OA_02
50:01:43:80:04:C4:28:83:50:01:43:80:04:C4:28:82 SP B 2
Host name: OA_02
50:01:43:80:04:C4:28:83:50:01:43:80:04:C4:28:82 SP A 3
Host name: OA_02
Pri/Sec Pairs:
Pri Number Sec Number
---------- ----------
1 12
0 11
Shareable: YES
Partition Name: Test_HA
Partition UID: 32:0A:16:A4:B3:42:DF:11:A8:64:00:60:16:36:04:02
HBA/SP Pairs:
HBA UID SP Name SPPort
------- ------- ------
50:01:43:80:04:C4:28:43:50:01:43:80:04:C4:28:42 SP A 0
Host name: Test_HA_01
50:01:43:80:04:C4:28:43:50:01:43:80:04:C4:28:42 SP B 1
Host name: Test_HA_01
50:01:43:80:04:C4:28:43:50:01:43:80:04:C4:28:42 SP A 2
Host name: Test_HA_01
50:01:43:80:04:C4:28:43:50:01:43:80:04:C4:28:42 SP B 3
Host name: Test_HA_01
50:01:43:80:04:C4:28:41:50:01:43:80:04:C4:28:40 SP B 0
Host name: Test_HA_01
50:01:43:80:04:C4:28:41:50:01:43:80:04:C4:28:40 SP A 1
Host name: Test_HA_01
50:01:43:80:04:C4:28:41:50:01:43:80:04:C4:28:40 SP B 2
Host name: Test_HA_01
50:01:43:80:04:C4:28:41:50:01:43:80:04:C4:28:40 SP A 3
Host name: Test_HA_01
50:01:43:80:04:C4:28:1B:50:01:43:80:04:C4:28:1A SP B 0
Host name: Test_HA_02
50:01:43:80:04:C4:28:1B:50:01:43:80:04:C4:28:1A SP A 1
Host name: Test_HA_02
50:01:43:80:04:C4:28:1B:50:01:43:80:04:C4:28:1A SP B 2
Host name: Test_HA_02
50:01:43:80:04:C4:28:1B:50:01:43:80:04:C4:28:1A SP A 3
Host name: Test_HA_02
50:01:43:80:04:C4:28:19:50:01:43:80:04:C4:28:18 SP A 0
Host name: Test_HA_02
50:01:43:80:04:C4:28:19:50:01:43:80:04:C4:28:18 SP B 1
Host name: Test_HA_02
50:01:43:80:04:C4:28:19:50:01:43:80:04:C4:28:18 SP A 2
Host name: Test_HA_02
50:01:43:80:04:C4:28:19:50:01:43:80:04:C4:28:18 SP B 3
Host name: Test_HA_02
Pri/Sec Pairs:
Pri Number Sec Number
---------- ----------
3 2
4 4
0 1
1 3
5 6
2 5
Shareable: YES
Partition Name: File
Partition UID: 89:93:22:AE:B3:42:DF:11:A8:64:00:60:16:36:04:02
HBA/SP Pairs:
HBA UID SP Name SPPort
------- ------- ------
20:00:00:1B:32:92:32:B6:21:00:00:1B:32:92:32:B6 SP B 0
Host name: File_01
20:00:00:1B:32:92:32:B6:21:00:00:1B:32:92:32:B6 SP A 1
Host name: File_01
20:00:00:1B:32:92:32:B6:21:00:00:1B:32:92:32:B6 SP B 2
Host name: File_01
20:00:00:1B:32:92:32:B6:21:00:00:1B:32:92:32:B6 SP A 3
Host name: File_01
20:00:00:1B:32:92:1D:60:21:00:00:1B:32:92:1D:60 SP A 0
Host name: File_01
20:00:00:1B:32:92:1D:60:21:00:00:1B:32:92:1D:60 SP B 1
Host name: File_01
20:00:00:1B:32:92:1D:60:21:00:00:1B:32:92:1D:60 SP A 2
Host name: File_01
20:00:00:1B:32:92:1D:60:21:00:00:1B:32:92:1D:60 SP B 3
Host name: File_01
Pri/Sec Pairs:
Pri Number Sec Number
---------- ----------
2 8
0 7
3 10
1 9
Shareable: YES
What I want is: (Sorting based on "Pri Number" column)
Output like this:
Partition Name Partition UID Host Name Pri Number Sec Number Shareable
------------------ ------------------ -------------- --------------- ---------------- ------------
OA 88:93...:02 OA_02 0 11 Yes
OA 88:93...:02 OA_02 1 12 Yes
Test_HA 32:0A...:02 Test_HA_01/Test_HA_02 0 1 Yes
Test_HA 32:0A...:02 Test_HA_01/Test_HA_02 1 3 Yes
Test_HA 32:0A...:02 Test_HA_01/Test_HA_02 2 5 Yes
Test_HA 32:0A...:02 Test_HA_01/Test_HA_02 3 2 Yes
Test_HA 32:0A...:02 Test_HA_01/Test_HA_02 4 4 Yes
Test_HA 32:0A...:02 Test_HA_01/Test_HA_02 5 6 Yes
File 89:93...:02 File_01 0 7 Yes
File 89:93...:02 File_01 1 9 Yes
File 89:93...:02 File_01 2 8 Yes
File 89:93...:02 File_01 3 10 Yes