'''
python
import re
import openpyxl
from openpyxl import Workbook
wb=Workbook()
sheet=wb.active
#注意下面的字符串要和匹配的文字一模一样,最好用www.regex101.com测试
patterns=(r" \*> Network : (\S+)\s+PrefixLen : (\d+)\s+",
r" NextHop : \S+\s+LocPrf :\s+",
r" MED : (\d+)\s+PrefVal : 0")
pattern = '\n'.join(patterns)
pattern_v4=re.compile(r" \*> (\S+/\d+)\s+\d{1,3}.\d{1,3}.\d{1,3}.\d{1,3}\s+(\d+)\s+\d+\s+\S+")
with open("1.txt","r") as f:
lines=f.read()
result=re.findall(pattern,lines)
result_v4=re.findall(pattern_v4,lines)
for i in range(len(result)):
sheet.append([result[i][0]+" "+result[i][1],result[i][2]])
for i in range(len(result_v4)):
sheet.append(result_v4[i])
wb.save("result.xlsx")
<HWNE40EX8A>display bgp vpnv4 vpn-instance AAA_HA routing-table peer 1.1.73.82 ad
BGP Local router ID is 0.0.0.0
Status codes: * - valid, > - best, d - damped, x - best external, a - add path,
h - history, i - internal, s - suppressed, S - Stale
Origin : i - IGP, e - EGP, ? - incomplete
RPKI validation codes: V - valid, I - invalid, N - not-found
VPN-Instance AAA_HA, Router ID 1.1.62.128:
Total Number of Routes: 1
Network NextHop MED LocPrf PrefVal Path/Ogn
*> 1.12.21.0/24 1.1.73.81 11 0 65007i
<HWNE40EX8A>display bgp vpnv6 vpn-instance AAA_Public routing-table peer 2001:2001:936:87F1:301::1 ad
BGP Local router ID is 0.0.0.0
Status codes: * - valid, > - best, d - damped, x - best external, a - add path,
h - history, i - internal, s - suppressed, S - Stale
Origin : i - IGP, e - EGP, ? - incomplete
RPKI validation codes: V - valid, I - invalid, N - not-found
Total Number of Routes: 4
*> Network : 2001:2000:936:: PrefixLen : 48
NextHop : 2001:2001:936:87F1:301:: LocPrf :
MED : 0 PrefVal : 0
Label :
Path/Ogn : 65007i
*> Network : 2001:2000:8936:: PrefixLen : 48
NextHop : 2001:2001:936:87F1:301:: LocPrf :
MED : 0 PrefVal : 0
Label :
Path/Ogn : 65007i
'''