Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Awk script to convert csv to html
Top Forums Shell Programming and Scripting Awk script to convert csv to html Post 302400649 by zeebala1981 on Wednesday 3rd of March 2010 08:12:11 PM
Old 03-03-2010
Question 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

Code:
./csv2html  | more
+ awk -v border=1 -v width=10 -v bgcolor=black -v fgcolor=white
BEGIN { printf("<table border=\"%d\" bordercolor=\"%s\" width=\"%d\" bgcolor=\"%s\"\n>",border,bgcolor,width,fgcolor) "<th>" "Hostname" "</th>" "<th>" "Volstat" "</th>" "Pairstat" "</th>" }
{
  print "<tr>";
  for( i = 1 ; i <= NF ; ++i )
    print "<td> "$i" </td>"
  print "</tr>"
}
END {  print "</table>" }  /tmp/offshore/out/11.csv

awk: cmd. line:2: BEGIN { printf("<table border=\"%d\" bordercolor=\"%s\" width=\"%d\" bgcolor=\"%s\"\n>",border,bgcolor,width,fgcolor) "<th>" "Hostname" "</th>" "<th>" "Volstat" "</th>" "Pairstat" "</th>" }
awk: cmd. line:2:                                                                                                                       ^ parse error

Last edited by Scott; 03-03-2010 at 09:21 PM.. Reason: Please use code tags
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

convert this into csv using awk/shell script

Hi Scripting gurus, I need to convert following text snippet into csv. please help Input heading1 = data1 heading2 = data2 .. .. heading n = data n heading 1 = data1 .. .. Output data1,data2,....,data n (3 Replies)
Discussion started by: azs0309
3 Replies

2. Shell Programming and Scripting

Script to Convert HTML to MIME mail -- HELP!

Hi: I have writed a script that read a HTML file and convert this in a multipart mime fail to send in a mail. But the result isn't interpreted lika a mime file!! Somebody can see the error??? --------------------------- #! /bin/bash SB=$1 IF=$2 OF=$3 rm -f $OF.b64 ... (7 Replies)
Discussion started by: sushisan
7 Replies

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

4. Programming

awk script to convert a text file into csv format

hi...... thanks for allowing me to start a discussion i am collecting usb usage details of all users and convert it into csv files so that i can export it into some database.. the input text file is as follows:- USB History Dump by nabiy (c)2008 (1) --- Kingston DataTraveler 130 USB... (2 Replies)
Discussion started by: certteam
2 Replies

5. Shell Programming and Scripting

awk convert xml to csv

Hi, I have an xml file and I want to convert it with awk in to a csv file Test.xml <Worksheet ss:Name="Map1"> <Table ss:ExpandedColumnCount="2" ss:ExpandedRowCount="2" x:FullColumns="1" x:FullRows="1" ss:DefaultColumnWidth="60"> <Row> <Cell><Data... (6 Replies)
Discussion started by: research3
6 Replies

6. Shell Programming and Scripting

Need to convert datafeed to html using script

Hi All, I am having datafeed content in CSV format like below. Any help to create a script. I need read the CSV file on loop and update it in html format for web publishing I want to chage the data using my token based template and save the file out to new csv file (3 Replies)
Discussion started by: ranjancom2000
3 Replies

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

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

9. Shell Programming and Scripting

Convert XML to CSV using awk or shell script

Hello, I am working on a part of code where I need a awk or shell script to convert the given XML file to CSV or TXT file. There are multiple xml files and of different structure, so a single script is required for converting data. I did find a lot of solutions in the forum but... (16 Replies)
Discussion started by: Rashmitha
16 Replies

10. Shell Programming and Scripting

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. #!/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... (0 Replies)
Discussion started by: archana25
0 Replies

LEARN ABOUT DEBIAN

bio::graphics::glyph::phylo_align

Bio::Graphics::Glyph::phylo_align(3pm)			User Contributed Perl Documentation		    Bio::Graphics::Glyph::phylo_align(3pm)

NAME

       Bio::Graphics::Glyph::phylo_align - The "phylogenetic alignment" glyph

SYNOPSIS

	 See L<Bio::Graphics::Panel> and L<Bio::Graphics::Glyph>.

DESCRIPTION

       This glyph draws a cladogram for any set of species along with their alignment data in relation to the reference species.  At high
       magnification, base pair alignements will be displayed.	At lower magnification, a conservation score plot will be drawn.  Gaps as
       specified by CIGAR are supported.  Currently the scores are drawn to a log plot with the restriction that the score will be the same across
       all base pairs within an alignment.  It is hoped that this restriction can be addressed in the future.

       For this glyph to work, the feature must return a DNA sequence string in response to the dna() method.  Also, a valid tree file must be
       available in a format readable by the Bio::Tree library.

   OPTIONS
       The following options are standard among all Glyphs.  See Bio::Graphics::Glyph for a full explanation.

	 Option      Description		      Default
	 ------      -----------		      -------

	 -fgcolor      Foreground color 	      black

	 -outlinecolor Synonym for -fgcolor

	 -bgcolor      Background color 	      turquoise

	 -fillcolor    Synonym for -bgcolor

	 -linewidth    Line width		      1

	 -height       Height of glyph		      10

	 -font	       Glyph font		      gdSmallFont

	 -connector    Connector type		      0 (false)

	 -connector_color
		       Connector color		      black

	 -label        Whether to draw a label	      0 (false)

	 -description  Whether to draw a description  0 (false)

	 -hilite       Highlight color		      undef (no color)

       In addition to the common options, the following glyph-specific options are recognized:

	 Option      Description	       Default
	 ------      -----------	       -------

	 -draw_clado_left
		     Draws the Cladogram on left 0

	 -species_spacing
		     Spacing of species in DNA	 1
		     mode in units of font height

	 -species_spacing_score
		     Spacing of spcies in	 5
		     conservation view in units
		     of font height

	 -hide_label Whether to label spcies	 0

	 -tree_file  Path of file containing	 undef
		     cladogram tree information
	 -tree_format Format of tree file	  newick

	 -axis_color Color of the vertical axes  fgcolor
		     in the GC content graph

	 -errcolor   Color of all misalignment	 fgcolor
		     indicators

	 -mid_axis_color
		     Color of the middle axis of
		     the conservation score graph axis_color

	 -clado_bg  Color of the clado bg	bgcolor
		     indicators

	 -ref_color  Color of base pair bg for	 bgcolor
		     the reference sequence

	 -targ_color Color of base pair bg for	 bgcolor
		     all base pairs that match
		     reference

BUGS

       Please report them.

SEE ALSO

       Bio::Graphics::Panel, Bio::Graphics::Glyph, Bio::Graphics::Glyph::arrow, Bio::Graphics::Glyph::cds, Bio::Graphics::Glyph::crossbox,
       Bio::Graphics::Glyph::diamond, Bio::Graphics::Glyph::dna, Bio::Graphics::Glyph::dot, Bio::Graphics::Glyph::ellipse,
       Bio::Graphics::Glyph::extending_arrow, Bio::Graphics::Glyph::generic, Bio::Graphics::Glyph::graded_segments,
       Bio::Graphics::Glyph::heterogeneous_segments, Bio::Graphics::Glyph::line, Bio::Graphics::Glyph::pinsertion, Bio::Graphics::Glyph::primers,
       Bio::Graphics::Glyph::rndrect, Bio::Graphics::Glyph::segments, Bio::Graphics::Glyph::ruler_arrow, Bio::Graphics::Glyph::toomany,
       Bio::Graphics::Glyph::transcript, Bio::Graphics::Glyph::transcript2, Bio::Graphics::Glyph::translation, Bio::Graphics::Glyph::triangle,
       Bio::DB::GFF, Bio::SeqI, Bio::SeqFeatureI, Bio::Das, GD

AUTHORS

       Hisanaga Mark Okada Lincoln Stein <lstein@cshl.org>.

       Copyright (c) 2001 Cold Spring Harbor Laboratory

       This library is free software; you can redistribute it and/or modify it under the same terms as Perl itself.  See DISCLAIMER.txt for
       disclaimers of warranty.

perl v5.14.2							    2012-02-20				    Bio::Graphics::Glyph::phylo_align(3pm)
All times are GMT -4. The time now is 03:30 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy