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 MOJAVE
new_printf_comp
XPRINTF_COMP(3) BSD Library Functions Manual XPRINTF_COMP(3)
NAME
free_printf_comp, new_printf_comp -- extensible printf compilation
SYNOPSIS
#include <printf.h>
void
free_printf_comp(printf_comp_t pc);
printf_comp_t
new_printf_comp(printf_domain_t restrict domain, locale_t restrict loc, const char * restrict fmt);
DESCRIPTION
To ameliorate some of the slowness caused by the extra overhead in extensible printf (see xprintf(5)), a compile/execute mechanism has been
created. The new_printf_comp() function compiles the given format string, along with a printf domain (see xprintf_domain(3)) and an extended
locale (see xlocale(3)), and returns a printf_comp_t structure. The domain may not be NULL, but the locale can be NULL, which means to use
the current locale, either the per-thread locale if it was set, or else the global locale. Because the printf_comp_t structure records the
domain and locale, care should be taken if either of these are changed.
Once a printf_comp_t structure is created, it can be passed to one of the extensible printf execution variants, described in xprintf_exec(3),
along with the necessary arguments. Creating the printf_comp_t structure needs to be done only once, but it can be passed to extensible
printf execution variants any number of times.
When the printf_comp_t structure is no longer needed, it should be passed to free_printf_comp() to release internal memory.
RETURN VALUES
The new_printf_comp() function returns the new structure, or NULL on error (usually NULL domain or out of memory condition).
SEE ALSO
xlocale(3), xprintf_domain(3), xprintf_exec(3), xprintf(5)
Darwin Aug 19, 2012 Darwin