Python正则表达式匹配交换机输出失效问题求助

Hey there! Let's dig into fixing that regex issue you're having with parsing your switch output.

First off, your hunch about adding ^ is spot-on—without anchoring the regex to the start of each line, it might be matching random fragments of text scattered throughout your files (like lines from show run that happen to have similar patterns) instead of the actual interface data rows from show ip interface brief.

Let's refine that regex #

Here's a adjusted version tailored to typical switch output, with explanations of each part:

^([A-Za-z]+)(\d+)\/(\d+)\/?(\d?)\s+(\S+)\s+(\S+)\s+\S+\s+(\S+)\s+(\S+)

Breaking down each capture group:

• ([A-Za-z]+): Catches the interface type (e.g., GigabitEthernet, FastEthernet, or shorthand like Gi/Fa)
• (\d+)\/(\d+)\/?(\d?): Captures the interface numbering (handles both dual-slash like 0/0 and triple-slash like 0/0/1 setups; the last digit is optional)
• \s+: Matches one or more whitespace characters (switches use variable spaces/tabs in output, so this is more reliable than \W+ which includes non-word characters you don't want)
• (\S+): Captures the IP address (or unassigned if no IP is set)
• (\S+): Catches the OK? status (e.g., YES/NO)
• \S+: Skips the Method column (we don't need to capture this)
• (\S+): Captures the interface Status (e.g., up/down)
• (\S+): Captures the Protocol status (e.g., up/down)

Example Python implementation #

Here's how you can use this regex in your code to parse the files and prepare data for your database:

import re

# Compile the regex once for efficiency
intf_pattern = re.compile(r'^([A-Za-z]+)(\d+)\/(\d+)\/?(\d?)\s+(\S+)\s+(\S+)\s+\S+\s+(\S+)\s+(\S+)')

with open('switch_192.168.1.1_output.txt', 'r') as f:
    for line in f:
        stripped_line = line.strip()
        # Skip header rows or empty lines
        if not stripped_line or stripped_line.startswith('Interface'):
            continue
        
        match = intf_pattern.match(stripped_line)
        if match:
            # Extract captured groups
            intf_type = match.group(1)
            intf_part1 = match.group(2)
            intf_part2 = match.group(3)
            intf_part3 = match.group(4) or ""  # Handle interfaces without a third segment
            ip_addr = match.group(5)
            ok_status = match.group(6)
            link_status = match.group(7)
            proto_status = match.group(8)
            
            # Example: Print parsed data (replace with your database insert logic)
            full_intf_name = f"{intf_type}{intf_part1}/{intf_part2}"
            if intf_part3:
                full_intf_name += f"/{intf_part3}"
            print(f"Interface: {full_intf_name} | IP: {ip_addr} | Status: {link_status}/{proto_status}")

Why your original regex failed #

Without the ^ anchor, your regex could match any substring in the file that fits the pattern—for example, lines from show run like interface GigabitEthernet0/0/1 might get partially matched, leading to broken or incorrect data. Anchoring to the start of the line ensures you only target the structured rows from show ip interface brief.

If you still run into issues, double-check a sample of your switch output—some vendors have slightly different column order or whitespace handling, so you might need to tweak the \s+ counts or add optional groups for edge cases (like interfaces with no IP assigned).

内容的提问来源于stack exchange，提问作者Beano