04-22-2008
Try this awk
awk 'BEGIN{
FS="|"
print "<HTML><BODY><TABLE border=1>"
}
{
printf "<TR>"
if(i=1)
printf "<TD ALIGN=\"LEFT\" width=\"100\" height=\"25\"><font size=\"2\" face=\"Verdana\"><b>%s</font></b></TD>", $i
if(i=2)
printf "<TD ALIGN=\"LEFT\" width=\"300\" height=\"25\"><font size=\"2\" face=\"Verdana\">%s</font></TD>", $i
if(i=3)
printf "<TD ALIGN=\"LEFT\" width=\"80\" height=\"25\"><font size=\"2\" face=\"Verdana\">%s</font></TD>", $i
if(i=4)
printf "<TD ALIGN=\"LEFT\" width=\"80\" height=\"25\"><font size=\"2\" face=\"Verdana\">%s</font></TD>", $i
if(i=5)
printf "<TD ALIGN=\"LEFT\" width=\"80\" height=\"25\"><font size=\"2\" face=\"Verdana\">%s</font></TD>", $i
if(i=6)
printf "<TD ALIGN=\"LEFT\" width=\"80\" height=\"25\"><font size=\"2\" face=\"Verdana\">%s</font></TD>", $i
}
END{
print "</TABLE></BODY></HTML>"
}
' file.txt >> file1.xls
****** i-- has number of records
******delimiter is " |"
it's return XLS files and open in windows.
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Hi, I need to convert a relatively large html file (1.5megs) into CSV under Unix. How would I be able to do this?
Much thanks. (3 Replies)
Discussion started by: Jexel
3 Replies
2. Shell Programming and Scripting
Hi,
Im new to shell scripting. My task is to convert shell script feed into html, so basically I have a lot of information in shell script and I want to convert it html. I know you can simply convert the information by hand, but is there any simpler way? Thank you
Dave (3 Replies)
Discussion started by: davwel
3 Replies
3. Shell Programming and Scripting
Hi,
I need to convert a text file formatted like this ("tshark -z conv,ip" output) to HTML:
=====================================================================================================
IPv4 Conversations
Filter:<No Filter>
| <- ... (4 Replies)
Discussion started by: ph0enix
4 Replies
4. Shell Programming and Scripting
Hi All,
I have a requirement of converting an html form into pdf using perl.
The html form contains images, tables and css implementation. I tried using various perl modules but failed to achive the target.
I succeeded in generating a pdf from the html file using... (2 Replies)
Discussion started by: DILEEP410
2 Replies
5. Shell Programming and Scripting
Hi,
Basically what I am trying to do is the following.
I have created a shell script to grab timetabling information from a website using curl then I crop out only the data I need which is a table based on the current date. It leaves me with a file that has the table I want plus a small amount... (2 Replies)
Discussion started by: domsmith
2 Replies
6. Shell Programming and Scripting
I have a spreadsheet in a folder that looks like this:
Sector1...Sector2...Sector3...Sector4...Sector5...Sector6...Sector7
SomeID....Title.......SomeID...SomeID....SomeID...SomeID....SomeID
OtherID...MyTitle....SomeID...SomeID....SomeID...SomeID....SomeID... (7 Replies)
Discussion started by: Xterra
7 Replies
7. Shell Programming and Scripting
I'm pulling down some LUN usage data once per day. I store the data in a file name that matches the name of the LUN. Then I just append new usage amounts to the same file each day.
Filename might be serv01_luna, serv01_lunb, serv01_lunc, etc, etc.
Inside the file it would like the following... (7 Replies)
Discussion started by: dwcasey
7 Replies
8. Shell Programming and Scripting
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. (1 Reply)
Discussion started by: archana25
1 Replies
9. UNIX for Beginners Questions & Answers
Hello Everyone,
I have the following text file with the each field separated by newline
Text file
P
file1-en-us_US-20170718T150157Z.json
Wed 19 Jul 2017 06:10:13 AM EDT
P
file2-en-us_US-20170718T160150Z.json
Wed 19 Jul 2017 06:10:13 AM EDT
P
file3-en-us_US-20170718T163218Z.json
Wed... (9 Replies)
Discussion started by: nextStep
9 Replies
10. Shell Programming and Scripting
Hello everybody, :)
I need some help with a school project that I have to create for the next week. :eek:
So first, the aim of the Script is that I have a WebSite with a lot of .html / .shtml / .js / .css in one directory. That directory have few directory too but that's not so important,... (1 Reply)
Discussion started by: mariocrocop
1 Replies
LEARN ABOUT DEBIAN
explain_printf_or_die
explain_printf_or_die(3) Library Functions Manual explain_printf_or_die(3)
NAME
explain_printf_or_die - formatted output conversion and report errors
SYNOPSIS
#include <libexplain/printf.h>
int explain_printf_or_die(const char *format);
int explain_printf_on_error(const char *format);
DESCRIPTION
The explain_printf_or_die function is used to call the printf(3) system call. On failure an explanation will be printed to stderr, obtained
from the explain_printf(3) function, and then the process terminates by calling exit(EXIT_FAILURE).
The explain_printf_on_error function is used to call the printf(3) system call. On failure an explanation will be printed to stderr,
obtained from the explain_printf(3) function, but still returns to the caller.
format The format, exactly as to be passed to the printf(3) system call.
RETURN VALUE
The explain_printf_or_die function only returns on success, see printf(3) for more information. On failure, prints an explanation and
exits, it does not return.
The explain_printf_on_error function always returns the value return by the wrapped printf(3) system call.
EXAMPLE
The explain_printf_or_die function is intended to be used in a fashion similar to the following example:
int result = explain_printf_or_die(format);
SEE ALSO
printf(3)
formatted output conversion
explain_printf(3)
explain printf(3) errors
exit(2) terminate the calling process
COPYRIGHT
libexplain version 0.52
Copyright (C) 2010 Peter Miller
explain_printf_or_die(3)