Convert shell script output txt file to html table


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Convert shell script output txt file to html table
# 1  
Old 08-28-2016
Convert shell script output txt file to html table

My concnern related to the post
-Convert shell script output txt file to html table,
in this how to print the heading as color.
Code:
awk 'BEGIN{print "<table>"} {print "<tr>";for(i=1;i<=NF;i++)print "<td>" $i"</td>";print "</tr>"} END{print "</table>"}' <filename>


Last edited by vbe; 08-28-2016 at 07:30 AM.. Reason: code tags
# 2  
Old 08-28-2016
Try

Code:
[akshay@localhost tmp]$ cat f
col
1
2
3
4

Code:
[akshay@localhost tmp]$ awk 'BEGIN{print "<table>"}{c="td"; e=""}FNR==1{c="th";e=" style=\"color=red;\""}{print "<tr>";for(i=1;i<=NF;i++)printf("<%s%s>%s</%s>\n",c,e,$i,c); print "</tr>"} END{print "</table>"}' f 
<table>
<tr>
<th style="color=red;">col</th>
</tr>
<tr>
<td>1</td>
</tr>
<tr>
<td>2</td>
</tr>
<tr>
<td>3</td>
</tr>
<tr>
<td>4</td>
</tr>
</table>

Readable version
Code:
awk '
BEGIN{
            print "<table>"
}
{
    c="td"
    e=""
}
FNR==1{
     c="th";
     e=" style=\"color=red;\""
}
{
         print "<tr>"
         for(i=1;i<=NF;i++)
                   printf("<%s%s>%s</%s>\n",c,e,$i,c);
         print "</tr>"
} 
END{
         print "</table>"
}' infile

This User Gave Thanks to Akshay Hegde For This Post:
# 3  
Old 08-28-2016
i tried with above code but it is not display the heading as color. no luck.
Code:
awk 'BEGIN{print "<table border=1 width=100% cellspacing=0 cellpadding=0 align=center>"}{c="td"; e=""}FNR==1{c="th";e=" style=\"color=red;\""}{print "<tr>";for(i=1;i<=NF;i++)printf("<%s%s>%s</%s>\n",c,e,$i,c); print "</tr>"} END{print "</table>"}' mail_send.txt

can you please suggest me to fix this.


Moderator's Comments:
Mod Comment Please use CODE tags as required by forum rules!

Last edited by RudiC; 08-28-2016 at 02:48 PM.. Reason: Added CODE tags.
# 4  
Old 08-28-2016
Try <th style="color:red">
# 5  
Old 08-28-2016
Or perhaps <th bgcolor=red style="color:white">
# 6  
Old 08-28-2016
Oh Sorry my mistake,

change
Code:
e=" style=\"color=red;\""

to
Code:
e=" style=\"color:red;\""

# 7  
Old 08-29-2016
i tried as per your modification even though it does not display the heading as color.
Code:
awk 'BEGIN{print "<table border=1 width=100% cellspacing=0 cellpadding=0 align=center>"}{c="td"; e=""}FNR==1{c="th";e=" style=\"color:red;\""}{print "<tr>";for(i=1;i<=NF;i++)printf("<%s%s>%s</%s>\n",c,e,$i,c); print "</tr>"} END{print "</table>"}' mail_send.txt

---------- Post updated at 12:34 AM ---------- Previous update was at 12:32 AM ----------

Hi Chubler,

where to use this code: <th bgcolor=red style="color:white">

i'm confusing ..can you please give me full line code.



Moderator's Comments:
Mod Comment Please use CODE tags as required by forum rules!

Last edited by RudiC; 08-29-2016 at 03:08 AM.. Reason: Added CODE tags.
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Awk, sed, shell all words in INPUT.txt find in column1 of TABLE.txt and replce with column2 in

Hi dears i have text file like this: INPUT.txt 001_1_173 j nuh ]az 001_1_174 j ]esma. nuh ]/.xori . . . and have another text like this TABLE.txt j j nuh word1... (6 Replies)
Discussion started by: alii
6 Replies

2. UNIX for Dummies Questions & Answers

Convert Txt file to HTML table and email

Hi all I need help converting a text file into a html table in bash and I need to email this table. The text file looks like the below. Two columns with multiple rows. Top row being header. Application Name Application Status Application 1 Open Application 2 ... (2 Replies)
Discussion started by: hitmanjd
2 Replies

3. Shell Programming and Scripting

[Solved] Shell script output in HTML or with table like results and mail

Hello, Currently i have a script which will disply the results in plain text format. I want to format the result in more readable format like Making bold headings and format with colors etc. Something like html and send that content as email. Please help me how i can do that. I am using... (10 Replies)
Discussion started by: joy lobo
10 Replies

4. Shell Programming and Scripting

Need to convert output.txt into html file

I have output.txt file generated through shell scripts which need convert in tabular format using html can you please help me output.txt Token State Date1 Date2 Description Name 34567 open 27/06/13 28/06/13 ... (5 Replies)
Discussion started by: vijay_rajni
5 Replies

5. UNIX for Dummies Questions & Answers

How to Update DB table from txt file using CRONJOB in Unix Shell Script

Hi Experts, can guide how we can Update a Database Table using a txt file source Using Unix Shell Scripts. What are the Cron Jobs codes can written to Update DB table. txt file contains record like data. US 09/03/2012 User DocType DocID. these above feilds in txt files need to be updated in... (4 Replies)
Discussion started by: mahesh.sap
4 Replies

6. Shell Programming and Scripting

Convert shell script output txt file to html table

Hi, I have script which generates the output as below: Jobname Date Time Status abc 12/9/11 17:00 Completed xyz 13/9/11 21:00 Running I have the output as a text file. I need to convert it into a HTML Table and sent it thru email ... (6 Replies)
Discussion started by: a12ka4
6 Replies

7. Shell Programming and Scripting

Bash shell script that inserts a text data file into an HTML table

hi , i need to create a bash shell script that insert a text data file into an html made table, this table output has to mailed.I am new to shell scripting and have a very minimum idea of shell scripting. please help. (9 Replies)
Discussion started by: intern123
9 Replies

8. Shell Programming and Scripting

shell script output in HTML or with table like results

Hello, Currently i have a ksh script which will disply the results in plain text format. I want to format the result in more readable format like Making bold headings and format with colors etc. Something like html or excel format and send that content as email. Please help me how i can do... (2 Replies)
Discussion started by: kotasateesh
2 Replies

9. Shell Programming and Scripting

Is it possible to convert text file to html table using perl

Hi, I have a text file say file1 having data like ABC c:/hm/new1 Dir DEF d:/ner/d sd ...... So i want to make a table from this text file, is it possible to do it using perl. Thanks in advance Sarbjit (1 Reply)
Discussion started by: sarbjit
1 Replies

10. Shell Programming and Scripting

Format txt file as html table

I have a short time to solve a problem, so I need some help. I've searched the forum, but I couldn't find a solution to my problem. I made a script to filter some text and now I have a new requirement to make it available as html table. Problem is that I more than one files with different set... (2 Replies)
Discussion started by: tetreb
2 Replies
Login or Register to Ask a Question