使用awk处理条件语句与变量：提取指定数据并计算差值

Let’s walk through how to tackle this specific data extraction task step by step—using command-line tools like awk which is perfect for row/column file processing:

• Step 1: Grab the fixed reference value
  First, we extract the value from the 6th line, 4th column and store it for later use:

  ref_val=$(awk 'NR==6 {print $4}' your_target_file.txt)
  

  Here, NR==6 targets the 6th line, and $4 pulls the 4th column’s value.

• Step 2: Find the closest value in column 1 of subsequent lines
  Next, we scan all lines after the 6th, calculate how close each column 1 value is to our reference, and track the line number of the closest match. Using squared difference avoids dealing with absolute values (it works the same for finding the minimum difference):

  closest_line=$(awk -v ref="$ref_val" 'NR>6 {diff=($1-ref)^2; if (diff<min || NR==7) {min=diff; line=NR}} END {print line}' your_target_file.txt)
  

  We initialize the minimum difference on the first post-6th line (NR==7) to avoid undefined values.

• Step 3: Extract the non-zero column 2 value from the next line
  With the line number of the closest value, we grab the line right after it, then pull column 2 (with a check to ensure it’s non-zero):

  target_val=$(awk -v line="$closest_line" 'NR==line+1 && $2!=0 {print $2}' your_target_file.txt)
  

• Step 4: Output values and calculate their difference
  Finally, we print both values and compute their difference (using bc -l for floating-point arithmetic):

  echo "Reference value: $ref_val"
  echo "Target value: $target_val"
  echo "Difference: $(echo "$ref_val - $target_val" | bc -l)"
  

Full Script for One-Click Execution #

Save this as extract_calculate.sh to run the whole workflow in one go:

#!/bin/bash
file="your_target_file.txt"

# Extract reference value
ref_val=$(awk 'NR==6 {print $4}' "$file")
echo "Reference value (Line 6, Column 4): $ref_val"

# Find closest value's line number
closest_line=$(awk -v ref="$ref_val" 'NR>6 {diff=($1-ref)^2; if (diff<min || NR==7) {min=diff; line=NR}} END {print line}' "$file")

# Get target non-zero value
target_val=$(awk -v line="$closest_line" 'NR==line+1 && $2!=0 {print $2}' "$file")
echo "Target value (Next line after closest, Column 2): $target_val"

# Calculate difference
diff=$(echo "$ref_val - $target_val" | bc -l)
echo "Final Difference: $diff"

Make it executable with chmod +x extract_calculate.sh, then run it with ./extract_calculate.sh.

Quick Notes #

• Replace your_target_file.txt with your actual file path.
• If bc isn’t installed on your system, you can use awk for the difference calculation too: awk -v r="$ref_val" -v t="$target_val" 'BEGIN {print r-t}'.
• If multiple lines have the same closest difference, this script picks the first occurrence. Adjust the awk logic if you need the last one instead.

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