Output 1 is all perfert I am able to get it but not sure how to get the result for Output 2 , I am not able to fix this part,
Huawei-INTMAC.csv | |||||||
---|---|---|---|---|---|---|---|
A | B | C | D | E | |||
6 | PE-AggX16A-Abha-701-2 | ---------------------------------------------------------------------------------------------------------------------- | Output 1 | Output 2 | |||
7 | PE-AggX16A-Abha-701-2 | 78da-6ea3-9c81 Vlan2427 - - Tun0/0/200 dynamic 1/31058 | |||||
8 | PE-AggX16A-Abha-701-2 | 0002-71e8-3eba 2027 - - Eth-Trunk4 dynamic 1/- | 0002-71e8-3eba | Eth-Trunk4 | |||
9 | PE-AggX16A-Abha-701-2 | 0002-71e7-9ea1 Vlan1031 3044 - Eth-Trunk6.1031 dynamic 1/- | 0002-71e7-9ea1 | Eth-Trunk6.1031 | |||
10 | PE-AggX16A-Abha-701-2 | 0002-71ca-8477 Vlan1031 3041 - Eth-Trunk5.1031 dynamic 1/- | 0002-71ca-8477 | Eth-Trunk5.1031 | |||
11 | PE-AggX16A-Abha-701-2 | 1845-9348-8ff1 Vlan1031 3044 - Eth-Trunk6.1031 dynamic 1/- | 1845-9348-8ff1 | Eth-Trunk6.1031 | |||
12 | PE-AggX16A-Abha-701-2 | f479-60ed-0fa4 BD 3201 - - Tun0/0/200 dynamic 1/32052 | |||||
13 | PE-AggX16A-Abha-701-2 | 0002-71f3-a0ab Vlan1031 3042 - Eth-Trunk4.1031 dynamic 1/- | 0002-71f3-a0ab | Eth-Trunk4.1031 | |||
14 | PE-AggX16A-Abha-701-2 | b426-5d8e-2e91 Vlan1031 3041 - Eth-Trunk63.3041 dynamic 1/- | b426-5d8e-2e91 | Eth-Trunk63.3041 | |||
15 | PE-AggX16A-Abha-701-2 | 0002-71f4-2875 Vlan1031 3044 - Eth-Trunk6.1031 dynamic 1/- | 0002-71f4-2875 | Eth-Trunk6.1031 | |||
16 | PE-AggX16A-Abha-701-2 | 0002-71fb-99d7 Vlan1031 3042 - Eth-Trunk4.1031 dynamic 1/- | 0002-71fb-99d7 | Eth-Trunk4.1031 | |||
17 | PE-AggX16A-Abha-701-2 | 1845-935c-f421 Vlan1031 3044 - Eth-Trunk6.1031 dynamic 1/- | 1845-935c-f421 | Eth-Trunk6.1031 | |||
18 | PE-AggX16A-Abha-701-2 | 803e-48b8-8e12 2029 - - Eth-Trunk6 dynamic 1/- | 803e-48b8-8e12 | Eth-Trunk6 | |||
19 | PE-AggX16A-Abha-701-2 | 0002-71fb-a04d Vlan1031 3041 - Eth-Trunk63.3041 dynamic 1/- | 0002-71fb-a04d | Eth-Trunk63.3041 | |||
20 | PE-AggX16A-Abha-701-2 | 0002-71fb-92da 2027 - - Eth-Trunk4 dynamic 1/- | 0002-71fb-92da | Eth-Trunk4 | |||
21 | PE-AggX16A-Abha-701-2 | f08e-db22-0883 3689 - - Eth-Trunk6 dynamic 1/- | f08e-db22-0883 | Eth-Trunk6 | |||
Huawei-INTMAC |
Cell Formulas | ||
---|---|---|
Range | Formula | |
D7:D21 | D7 | =IF(ISERROR(FIND(" Eth",B7)),"",TEXTBEFORE(B7," ")) |