AWK多文件字段匹配：简化节点链接判断的条件逻辑实现

Got it, let's ditch those messy if statements and leverage AWK's superpower—associative arrays—to handle this cross-file matching cleanly. This approach is not only more concise but also way more efficient than looping through both files repeatedly. Here's exactly how to implement your logic:

Step 1: Break Down the Mapping Logic #

First, we need to pre-process file2 to store two key-value mappings that align with your conditions:

• When file1's $2 + $3 matches file2's $1 + $3, we pull file2's $2
• When file1's $2 + $3 matches file2's $3 + $1, we pull file2's $4

Step 2: The AWK Script #

Create a script (let's call it match_links.awk) with this code:

# Process file2 first (NR == FNR means we're reading the first input file)
NR == FNR {
    # Store mapping for (file2 $1, file2 $3) → file2 $2
    map[$1, $3] = $2
    # Store mapping for (file2 $3, file2 $1) → file2 $4
    map[$3, $1] = $4
    next  # Skip to next line, don't process file1 logic yet
}

# Now process file1
{
    # Create a key from file1's $2 and $3 (comma-separated to avoid value collisions)
    lookup_key = $2 "," $3
    
    if (lookup_key in map) {
        # Match found: print file1's $2, the mapped value, then file1's $3
        print $2, map[lookup_key], $3
    } else {
        # No match: print your default "..." content (adjust this as needed)
        print $2, "...", $3
    }
}

Step 3: Run the Script #

Execute it by passing file2 first (we need to load its data into the array before processing file1):

awk -f match_links.awk file2 file1

Or use a one-liner if you don't want a separate script:

awk 'NR==FNR{map[$1,$3]=$2;map[$3,$1]=$4;next}{k=$2","$3;print $2, (k in map ? map[k] : "..."), $3}' file2 file1

Quick Tips #

• If your node values might contain commas, swap the comma separator in the array key for a character that won't appear in your data (like | or \t).
• Tweak the else block's print statement if your "default" content isn't just ...—you can include other fields from file1 or custom text here.

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