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


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Bash shell script that inserts a text data file into an HTML table
# 1  
Old 06-16-2011
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.
# 2  
Old 06-16-2011
Pls post sample input and the output you are expecting.
# 3  
Old 06-17-2011
Input and expected output

input:

email address
subject

processname param2 param3 param4 param5 param6
1 a b c d e
2
3..
4..
...
...
21..

output:

This content has to be put into an html table and mailed to the specifed address

Last edited by intern123; 06-17-2011 at 04:14 AM.. Reason: Incomplete response
# 4  
Old 06-17-2011
If the input file has the format you specify a Perl script seems the obvious route, the script below is untested and just an outline.

Quote:
Originally Posted by intern123
input:

email address
subject

processname param2 param3 param4 param5 param6
1 a b c d e
2
3..
4..
...
...
21..
Code:
#! /usr/bin/perl

use strict;
use warnings;

open (my $in_file , '<', "$ARGV[0]");
my $path_to_sendmail="/usr/sbin/sendmail -t";
my $position=0;# 0=>initial empty line(s), 1=>email address,2=>subject,3=>ignore empty line(s), 3=>table headings,4=>data lines
my (%mail);
while(<$in_file>){
   if ( ($position == 0 ) && (!/^\s*$/) ){ 
      chomp($mail{address}=$_);
      $position++;
   }
   elsif( ($position == 1) && (!/^\s*$/) ){
      chomp($mail{subject}=$_);
      $position++;
    }
   elsif( ($position == 2) && (/^\s*$/) ){
      $position++;
   }
   elsif ( ($position == 3) && (!/^\s*$/) ){
      $mail{body}="<html><head><title>$mail{subject}</title></head><body><table>";
      my @headings=split(/\s+/, $_);
      $mail{body}.='<tr><th>', join('</th><th>', @headings), '</th></tr>';
      $position++;
   }
   elsif ($position==4){
      my @record= split (/\s+/,$_);
      $mail{body}.= '<tr><td>', join('</th><td>', @record), '</td></tr>';
   }
}
$mail{body}.='</table></body></html>';
close ($in_file);
open (my $sendmail ,'|', "$path_to_sendmail") || die "Did you forget to set the location of your sendmail binary?, current value is \"$path_to_sendmail\"\n";
print $sendmail "From: monitoring.script\@localhost\n";ject
print $sendmail "To: $mail{address}\n";
print $sendmail "Content-type: text/html";
print $sendmail "Subject: $mail{subject}\n\n";
print $sendmail $mail{body};
close($sendmail);
exit;

# 5  
Old 06-17-2011
thanks a lot. will see if this works.
could this be done in a bash shell script using sed and awk utlities ?
# 6  
Old 06-17-2011
It probably could, Perl just seems a natural fit for the task though
# 7  
Old 06-17-2011
Given the sudden restrictions popping up in your other thread I have to ask if this is homework?
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

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. awk 'BEGIN{print "<table>"} {print "<tr>";for(i=1;i<=NF;i++)print "<td>" $i"</td>";print "</tr>"} END{print "</table>"}' <filename> (8 Replies)
Discussion started by: sarajobmai
8 Replies

2. Linux

Parsing - export html table data as .csv file?

Hi all, Is there any out there have a brilliant idea on how to export html table data as .csv or write to txt file with separated comma and also get the filename of link from every table and put one line per rows each table. Please see the attached html and PNG of what it looks like. ... (7 Replies)
Discussion started by: lxdorney
7 Replies

3. Shell Programming and Scripting

Input data of a file from perl into HTML table

Hi , I need an help in perl scripting. I have an perl script written and i have an for loop in that ,where as it writes some data to a file and it has details like below. cat out.txt This is the first line this is the second line. .....Now, this file needs to be send in mail in HTML... (2 Replies)
Discussion started by: scott_cog
2 Replies

4. Shell Programming and Scripting

Creating html table from data in file

Hi. I need to create html table from file which contains data. No awk please :) In example, ->cat file num1 num2 num3 23 3 5 2 3 4 (between numbers and words single TAB). after running mycode i need to get (heading is the first line): <table>... (2 Replies)
Discussion started by: Manu1234567
2 Replies

5. 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

6. UNIX for Dummies Questions & Answers

Bash script to insert data into an html table

hi, I need to create a bash shell script which picks up data from a text file and in the output file puts it into an html made table. I have to use sed and awk utilties to do this the input text file will contain data in the format: job name para1 para2 para3 para4 para4 1 ... (1 Reply)
Discussion started by: intern123
1 Replies

7. Shell Programming and Scripting

help with a bash script to create a html table

Hi guys as the title says i need a little help i have partisally written a bash script to create a table in html so if i use ./test 3,3 i get the following output for the third arguement in the script i wish to include content that will be replace the A characters in the... (2 Replies)
Discussion started by: dunryc
2 Replies

8. 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

9. Shell Programming and Scripting

unix shell script which inserts some records into a file located in remote servers...

All, I need to write an unix shell script which inserts some records into a file located in remote servers. * Get the input from the user and insert according the first row. It should be in ascending order. 123451,XA,ABA 123452,XB,ABB 123453,XC,ABC 123455,XE,ABE 123456,XF,ABF 123458,XG,ABG... (2 Replies)
Discussion started by: techychap
2 Replies

10. Shell Programming and Scripting

shell script to read data from text file and to load it into a table in TOAD

Hi....can you guys help me out in this script?? Below is a portion text file and it contains these: GEF001 000093625 MKL002510 000001 000000 000000 000000 000000 000000 000001 GEF001 000093625 MKL003604 000001 000000 000000 000000 000000 000000 000001 GEF001 000093625 MKL005675 000001... (1 Reply)
Discussion started by: pallavishetty
1 Replies
Login or Register to Ask a Question