Convert csv data to html format Post: 303001187

Sponsored Content

Top Forums Shell Programming and Scripting Convert csv data to html format Post 303001187 by archana25 on Friday 28th of July 2017 05:08:56 PM

07-28-2017

Registered User

Convert csv data to html format

I am new to html and need to convert the attached csv file data to html format ; running into issues. please assist.

Code:

#!/bin/ksh
echo "<html>" ;
echo "<head><style> table {border-collapse: collapse;} table, td, th {border: 1px solid black;} </style></head>"
echo "<title> REPORT </title>"
echo "<body><table border = '1' cellpadding=10>";
header=1
echo "<h1> REPORT </h1>"
IFS=','
while read -A line; do
length=${#line[@]}
if [[ "${length}" != "1" ]]; then
echo "<tr>"
for i in "${!line[@]}"; do
value=${line[i]}
if [[ "${header}" == "1" ]]; then
echo "<th>${value}</th>"
else
echo "<td>${value}</td>"
fi
done
echo "</tr>"
header=0
else
echo "</table> <br/><br/> <table border = '1' cellpadding=15>"
header=1
fi
done < report.csv ;
echo "</table></body></html>";

---------- Post updated at 05:08 PM ---------- Previous update was at 04:58 PM ----------

I wanted to create three tables in html file.

Moderator's Comments:

Please use code tags in your post - those are html tags, too

Last edited by jim mcnamara; 07-28-2017 at 07:36 PM..

archana25

View Public Profile for archana25

Find all posts by archana25

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Convert comma text file to Column in html format

I am trying to generate a report with below file : File1 : EQADM,edrtere9-phys,8122caef0,gpatmon,/bin/ksh,nuten Erick EQADM,edrtere11-phys,8227caef0,gpatmon,/bin/ksh,nuten Erick EQADM,edrtere3-phys,822caef0,gpatmon,/bin/ksh,nuten Erick can you help me convert it to html and add...

2. Shell Programming and Scripting

Convert XML to CSV format

Can any one give the idea on this, please. I have the following XML file and wants to convert into CSV(comma separated value) format. <?xml version='1.0' encoding='UTF-8'?> <!DOCTYPE Waveset PUBLIC 'waveset.dtd' 'waveset.dtd'> <Waveset> <Object name='ra8736'> <Attribute name='ADDRESS'...

3. UNIX for Dummies Questions & Answers

convert csv to html file

Hi All, I am new to this forum,not sure where to post this query...so posted here Kindly need any of your help on the below ------------ I am using shell scripting and trying to convert a csv file to html file... example.csv --------------- Name Country Age Sex Andy India 25 ...

4. Shell Programming and Scripting

Convert the below file to csv format

Hi , i want to change this question, i will post soon..

5. Shell Programming and Scripting

Awk script to convert csv to html

Hi Written some script to convert csv to html but could not add table headers.Below are the errors iam getting ./csv2html | more + awk -v border=1 -v width=10 -v bgcolor=black -v fgcolor=white BEGIN { printf("<table border=\"%d\" bordercolor=\"%s\" width=\"%d\"...

6. Shell Programming and Scripting

Script to convert CSV file to HTML

Hi, I have made a a script which creates a csv file as daily database report However i want to covert that csv file to html because csv file does not have a good visibilty. So it is possible to have such csv to html coversion script. Your prompt help much appreciated. Thanks in advance

7. Shell Programming and Scripting

Script to convert csv file to html with good visibility

Hi, I have Below script which converts csv file to html succesfully.but the visiblity is simple in black n white. I want to have better visibilty of each columns in different colours(like green).As it is a Database report suppose some tablespace available space is less than 20% then it should...

8. Shell Programming and Scripting

Convert text file to HTML tabular format.

Please provide script/commands to convert text file to HTML tabular format. No need of styles and colours, just output and a heading in table is required. Output file will be send via email and will be seen from outlook. (script required without using awk). output file content: (sar...

9. Shell Programming and Scripting

Loop to convert text output in the HTML format

Hello Everyone, I have a sample file raw.txt as shown below : Drive Bays Bay Name : SD-2C Number of Standby Power Supplies : 4 Number of Drive Enclosures : 12 Summary Status of Contained Modules All...

10. Shell Programming and Scripting

Converting csv to html format

Below is the code I have - How can I convert the data in the csv into 3 tables in html. instead of 1 table. Attached is the format I am getting.

LEARN ABOUT DEBIAN

xml2

XML2(1) 						      General Commands Manual							   XML2(1)

NAME

       xml2 - convert xml documents in a flat format

       2xml - convert flat format into xml

       html2 - convert html documents in a flat format

       2html - convert flat format into html

       csv2 - convert csv files in a flat format

       2csv - convert flat format into csv

SYNOPSIS

       <xml2|2xml|html2|2html|csv2|2csv> > outfile < infile

DESCRIPTION

       There are six tools. Except csv2 and and 2csv they don't take any command-line arguments.  They are all simple filters which can be used to
       read files from standard input in one format and output it to standard output in another format.

       The flat format used by the tools is specific to these tools.  It is a syntax for representing structured markup in a  way  that  makes	it
       easy  to process with line-oriented tools.  The same format is used for HTML and XML; in fact, you can think of html2 as converting HTML to
       XHTML and running xml2 on the result; likewise 2html and 2xml. (Of course, this isn't how the implementation works.)

SEE ALSO

       This program does normally not include any documentation in form of manpages.  However it has a real excellent documentation online with  a
       lot of example.	In fact this manpage was based on this documentation.

       Please find it on:

       http://dan.egnor.name/xml2/ref

       Examples can be found here:

       http://dan.egnor.name/xml2/examples

AUTHOR

       xml2 was written by Dan Egnor.

       This  manpage  was written by Patrick Schoenfeld <schoenfeld@in-medias-res.com> for the Debian project, but may be used by others under the
       same terms as xml2 is distributed.

BUGS

       Bugs can be reported through the Debian Bug tracking system.

								 7h february 2008							   XML2(1)