Hey there, let's break down and fix the awk issues you're running into!

First, let's tackle the "unterminated string" error #

This error almost always boils down to one of two common issues:

• Unmatched quotes: You’ve got an opening double quote (") somewhere in your awk script that doesn’t have a corresponding closing quote. For example, if you wrote print "20180131 \t (missing the final "), awk will think the string never ends and throw this error.
• Shell interference: If you’re running awk directly in the terminal and wrapped your script in double quotes instead of single quotes, the shell will try to parse variables or special characters inside the awk code, breaking your string structure. For example:

  # ❌ Bad: Shell parses the inner quotes and messes up awk's string
  awk "print "20180131 \t" $0" input.txt
  

Next, the mysterious leading spaces in your print statements #

Those spaces are likely coming from one of these scenarios:

1. Accidental indentation or copy-paste: If you’re writing the awk script directly in the terminal or a text editor, you might have accidentally added leading spaces before the print keyword (or even inside the string itself, like print " 20180131 \t").
2. Malformed line breaks in terminal commands: If you split your awk script across lines in the terminal without properly escaping the newline, the shell might introduce extra spaces when parsing the command.

Step-by-step fixes #

1. Use a separate awk script file for clarity
   Save your awk logic to a file (e.g., insert_values.awk)—this makes it way easier to spot syntax errors:

   # insert_values.awk
   BEGIN {
       OFS = "\t"  # Set output tab separator to avoid manual \t typing
   }
   # Replace this regex with the pattern of the line you want to insert after
   /YOUR_TARGET_LINE_PATTERN/ {
       # Print the original line first
       print $0
       # Insert your new date/mean/rms/bias line (no accidental leading spaces!)
       print "20180131", "1.23", "4.56", "0.78"
       next  # Skip processing the original line further
   }
   # Print all other lines normally
   { print }
   

   Run it with:

   awk -f insert_values.awk your_input_file.txt
   

   If there’s a quote issue, awk will tell you exactly which line has the problem.

2. Quote your awk script correctly in the terminal
   If you prefer running awk directly in the shell, wrap the entire awk code block in single quotes to prevent shell interference:

   awk '
   /YOUR_TARGET_LINE_PATTERN/ {
       print $0
       print "20180131\t1.23\t4.56\t0.78"  # No leading spaces here unless you want them in output
   }
   { print }
   ' your_input_file.txt
   

3. Trim accidental leading spaces
   Double-check your print statements—if you don’t want leading spaces in your output, simply delete any spaces before the opening quote of your string, or before the print keyword itself (awk allows indentation for readability, but it won’t affect output unless the spaces are inside your string).

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