awk print variable value

Question

I would like to print the variable value defined outside awk snippet.

Code Snippet

FailCounter=5

awk -v Fail=${FailCounter} -F, ' BEGIN {
        print "<TABLE border=1>"
        print "<TR><TD colspan=2> &nbsp;</font></TD></TR>"
} NR == 1 {
        print "<TR><TH colspan=2 bgcolor=\\#FECACA><font face=verdana size=3 color=black>Failed Status Summary</font></TH></TR>"
        print "<TR><TH bgcolor=\\#B7B1B1><font face=verdana size=3 color=black>" $1 "</font></TH>"
        print "<TH bgcolor=\\#B7B1B1><font face=verdana size=3 color=black>" $2 "</font></TH></TR>"
} NR > 1 {
        print "<TR><TD><font face=verdana size=3>" $1 "</font></TD>"
        print "<TD><font face=verdana size=3>" $2 "</font></TD></TR>"
} END {
        print "<TR><TD>Total</TD><TD>${FAIL}</TD></TR>"
        print "</TABLE>"
} ' ${ScanOutage} >> ${OutputFile}

The FailCounter variable is defined outside the awk block, I am unable to write -v Fail=${FailCounter} value in the END section of the awk script. It simply prints as is.

Please help me with this issue.

Current output

<TR><TD>Total</TD><TD>${FAIL}</TD></TR>

Intended output

<TR><TD>Total</TD><TD>5</TD></TR>

terdon · Accepted Answer · 2022-07-27 16:59:48Z

4

In awk, $foo does not mean "the value of the variable named foo", it means "the field whose number is the value of the variable foo". If you want to refer to a variable, you don't use $. For example:

$ echo "aa bb cc" | awk -v field=3 '{ print "field number",field, "is:",$field }'
field number 3 is: cc

So in your case, in order to print out the value of the awk variable Fail which you define on the command line, you need to print Fail and not $Fail and certainly not ${FAIL} since you don't have any variable called FAIL (things are case sensitive). So you are probably looking for something like this:

END{
   print "<TR><TD>Total</TD><TD>"Fail"</TD></TR>"
   print "</TABLE>"
}

Note how I need to close the quotes, then use the variable name, and then open new quotes.

answered Jul 27, 2022 at 16:59

terdon♦

252k69 gold badges480 silver badges718 bronze badges

Thank you @terdon. That worked.

VCP Muthukrishna
– VCP Muthukrishna

2022-07-27 17:05:32 +00:00
Commented Jul 27, 2022 at 17:05
You're welcome, @VCPMuthukrishna. If one of the answers here solved your issue, please take a moment and accept it by clicking on the checkmark on the left. That is the best way to express your thanks on the Stack Exchange sites.

terdon
– terdon ♦

2022-07-27 17:06:06 +00:00
Commented Jul 27, 2022 at 17:06

Add a comment |

Stack Exchange Network

awk print variable value

1 Answer 1

You must log in to answer this question.

Hot Network Questions

awk print variable value

1 Answer 1

You must log in to answer this question.

Related

Hot Network Questions