Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Splitting csv into 3 tables in html file
Top Forums Shell Programming and Scripting Splitting csv into 3 tables in html file Post 303001201 by jim mcnamara on Saturday 29th of July 2017 05:25:19 PM
Old 07-29-2017
Your awk needs to be changed slightly and put inside a loop:
Here is a simple sample. It writes everything to single html file, from 3 input files
Code:
#!/bin/ksh
echo "<HTML><BODY>" >> file1.html
for f in report.csv report2.csv  report3.csv   #loop
do

 awk 'BEGIN{
        FS=","
        print "<TABLE border = '1' cellpadding=10 width=100>"
   print "<head><style> table {border-collapse: collapse;} table, td, th {border: 1px solid black;} </style></head>"
     }
     {
        print "<TR>"
        for(i=1;i<=NF;i++)
        {
          printf ("<TD>%s</TD>\n", $i)
        }
        print "</TR>"
     }
     END{ print "</TABLE>" }
     ' "$f"  >> file1.html
done
echo "</BODY></HTML>"  >> file1.html

Please define 'changing width'.
 

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

help with splitting a html file up

hi i have a file called t.txt <p>The mayor is <a href="javascript:popupPerso('FichePersonnage.php?login=Yvaine')">Yvaine</a></p><p>The mentor is <a href="javascript:popupPerso(' FichePersonnage.php?login=Chaselambourne')">Chaselambourne</a></p>List of the villagers :<br><div id="Layer1"... (3 Replies)
Discussion started by: jeroen234
3 Replies

2. 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 Replies)
Discussion started by: sumithra
4 Replies

3. UNIX and Linux Applications

Does anybody know how to store my tables to a csv file?

Hi I'm using an oracle database... Lets call it databasename My username and password are the same .... lets all that andrea/andrea So I want to write a script to copy all the data from my table called tablename and store that data to a csv file called filename. I cant seem to get... (2 Replies)
Discussion started by: ladyAnne
2 Replies

4. UNIX for Advanced & Expert Users

Splitting the single csv file

Hi, I have a requiement where in i will get a single file but there will be mutiple headers. Suppose say for eg: Header1 Data... Data... Header2 Data.. Data.. Header3 Data.. Data.. I want to split each with the corresponding data into a single file. Please let me know how... (1 Reply)
Discussion started by: weknowd
1 Replies

5. 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 (4 Replies)
Discussion started by: sv0081493
4 Replies

6. Shell Programming and Scripting

Splitting input CSV file into 3 files

Hi , I am receiving a CSV file that can vary in number of rows each time. I am supposed to split this file into 3 separate files like this: 1. create a file named 'File1.csv' that will contain first 3 rows of the input file 2. create file named 'File2.csv' that will contain last 3 rows of the... (7 Replies)
Discussion started by: kedrick
7 Replies

7. Shell Programming and Scripting

Splitting CSV into variables then to XML file

I have a text file that looks like this: FIELD1, FIELD2, THIS IS FIELD3, FIELD4 FIELD1, FIELD2, THIS IS FIELD3, FIELD4 FIELD1, FIELD2, THIS IS FIELD3, FIELD4 I need it to turn it into an XML file to run against a custom application. My ultimate goal is for it to look like... (15 Replies)
Discussion started by: jeffs42885
15 Replies

8. Shell Programming and Scripting

Read CSV file and delete hdfs, hive and hbase tables

I have a CSV file with hdfs directories, hive tables and hbase tables. 1. first column - hdfs directories 2. second column - hive tables 3. third column - hbase tables I have to check the csv file and look for the first column and delete the hdfs directory from the hdfs path, now... (2 Replies)
Discussion started by: shivamayam
2 Replies

9. UNIX for Beginners Questions & Answers

Extract the tables from html

Hi I have a script which extracts the table from HTML and convert it into .csv. But the problem in the script is if we have 2 tables in HTMl . it takes only the first table. Please help me what changes i need to do in the script to make it read the complete HTML page. Script is as below: ... (10 Replies)
Discussion started by: deepti01
10 Replies

LEARN ABOUT CENTOS

tiffprintdirectory

TIFFPrintDirectory(3TIFF)												 TIFFPrintDirectory(3TIFF)

NAME

       TIFFPrintDirectory - print a description of a TIFF directory

SYNOPSIS

       #include <tiffio.h>

       void TIFFPrintDirectory(TIFF *tif, FILE *fd, long flags)

DESCRIPTION

       TIFFPrintDirectory  prints  a  description  of  the current directory in the specified TIFF file to the standard I/O output stream fd.  The
       flags parameter is used to control the level of detail of the printed information; it is a bit-or of the flags defined in tiffio.h:
       #define TIFFPRINT_NONE	       0x0     /* no extra info */
       #define TIFFPRINT_STRIPS        0x1     /* strips/tiles info */
       #define TIFFPRINT_CURVES        0x2     /* color/gray response curves */
       #define TIFFPRINT_COLORMAP      0x4     /* colormap */
       #define TIFFPRINT_JPEGQTABLES   0x100   /* JPEG Q matrices */
       #define TIFFPRINT_JPEGACTABLES  0x200   /* JPEG AC tables */
       #define TIFFPRINT_JPEGDCTABLES  0x200   /* JPEG DC tables */

NOTES

       In C++ the flags parameter defaults to 0.

RETURN VALUES

       None.

DIAGNOSTICS

       None.

SEE ALSO

       libtiff(3TIFF), TIFFOpen(3TIFF), TIFFReadDirectory(3TIFF), TIFFSetDirectory(3TIFF)

libtiff 							 December 12, 1991					 TIFFPrintDirectory(3TIFF)
All times are GMT -4. The time now is 11:22 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy