Issue
i have this csv file i successfully convert to html with the script below.
name,age
mike,109
sarah,25
#!/bin/bash
awk 'BEGIN {
h[1] = "name"
h[2] = "age"
FS=","
print "<!DOCTYPE html>" \
"<html>" \
"<head>" \
"<style>" \
"th { color:#f2f2f2; background-color: #73BD00;}th, td { text-align: left; padding: 8px; font-family: Arial;} {background-color: #f2f2f2;}" \
"th, td { text-align: left; padding: 8px; }" \
"tr { background-color: #f2f2f2;}" \
"</style>" \
"</head>" \
"<body>" \
"<h2> DATA TITLE </h2>" \
"<table border-collapse=collapse width=50%;> " \
}
#insert rows into table from file
{
print "<tr>"
#NF is a number of fields in each records
for (i=1;i<=NF;i++)
{
#insert first row of file as header
if (NR==1){
print "<th>" h[i] "</th>"
} else
print "<td>" $i "</td>"
}
print "</tr>"
}
END {
print "</table>"
"</body>" \
"</html>"
}' file.csv > filex.html;
Now i'm trying to figure out how to use either Sed or Awk to change the font color if the age is greater than 100.
What i've tried with SED:
I could have easily used Sed after the conversion like this if the value was just a generic number but the value changes depending on the file. What i'm trying to do is to have the value change color to RED only IF its greater than 100 which i'm not sure on how to do or if it's even possible
sed 's/109/<font color="red">9<\/font>/g' finalx.html > filey.html
What i've tried with AWK: i've tried to input this lines of codes into the conversion script in so many different ways but nothing seems to work.
NR>1 {
# Data rows
print "<tr>"
if( $i > 100 ) {
color="#FF0000" #color code for RED
}
print "</tr>"
}
i even tried editing the csv file before converting hoping that if i put the html font tag in the csv file with my condition, the conversion will pick it up and come out the way i intend but even my use of awk is wrong, so i didn't get that far to even test it out
awk -F "[, ]+" '$2>100{for(i=2; i<=NF; i++)$i="<font color="red">$i</font>"}1'
Any help is appreciated. Thanks
EDIT: here's the original code above formatted to be readable by gawk -o-:
BEGIN {
h[1] = "name"
h[2] = "age"
FS = ","
print "<!DOCTYPE html>" "<html>" "<head>" "<style>" "th { color:#f2f2f2; background-color: #73BD00;}th, td { text-align: left; padding: 8px; font-family: Arial;} {background-color: #f2f2f2;}" "th, td { text-align: left; padding: 8px; }" "tr { background-color: #f2f2f2;}" "</style>" "</head>" "<body>" "<h2> DATA TITLE </h2>" "<table border-collapse=collapse width=50%;> "
}
{
print "<tr>"
#NF is a number of fields in each records
for (i = 1; i <= NF; i++) {
#insert first row of file as header
if (NR == 1) {
print "<th>" h[i] "</th>"
} else {
print "<td>" $i "</td>"
}
}
print "</tr>"
}
#insert rows into table from file
END {
print "</table>"
"</body>" "</html>"
}
Solution
In this snippet
awk -F "[, ]+" '$2>100{for(i=2; i<=NF; i++)$i="<font color="red">$i</font>"}1'
you have unescaped " thus you will get
<font color=>$i</font>
where 2nd field is greater than 100, you need to escape " where there should mean literal " and concat strings with $i rather than use it inside string, i.e.
awk -F "[, ]+" '$2>100{for(i=2; i<=NF; i++)$i="<font color=\"red\">"$i"</font>"}1'
However this will casue lines which do fullfill $2>100 to be now space-separated and rest still comma-separated, to avoid this I suggest setting FS and OFS to comma, that is
awk 'BEGIN{FS=OFS=","}$2>100{for(i=2; i<=NF; i++)$i="<font color=\"red\">"$i"</font>"}1'
Answered By - Daweo Answer Checked By - Mildred Charles (WPSolving Admin)