Converting HTML data into a spreadsheet Post: 302187950

Sponsored Content

Top Forums Shell Programming and Scripting Converting HTML data into a spreadsheet Post 302187950 by koti_rama on Tuesday 22nd of April 2008 10:00:55 AM

04-22-2008

Registered User

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\">%s</TD>", $i
if(i=2)
printf "<TD ALIGN=\"LEFT\" width=\"300\" height=\"25\">%s</TD>", $i
if(i=3)
printf "<TD ALIGN=\"LEFT\" width=\"80\" height=\"25\">%s</TD>", $i
if(i=4)
printf "<TD ALIGN=\"LEFT\" width=\"80\" height=\"25\">%s</TD>", $i
if(i=5)
printf "<TD ALIGN=\"LEFT\" width=\"80\" height=\"25\">%s</TD>", $i
if(i=6)
printf "<TD ALIGN=\"LEFT\" width=\"80\" height=\"25\">%s</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.

koti_rama

View Public Profile for koti_rama

Find all posts by koti_rama

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Converting HTML to CSV

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.

2. Shell Programming and Scripting

Converting Shell Script to HTML

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. Shell Programming and Scripting

Converting a text file to HTML

Hi, I need to convert a text file formatted like this ("tshark -z conv,ip" output) to HTML: ===================================================================================================== IPv4 Conversations Filter:<No Filter> | <- ...

4. Shell Programming and Scripting

Converting html to pdf perl

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

5. Shell Programming and Scripting

Converting html table data into multiple variables.

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

6. Shell Programming and Scripting

Renaming files based on data in a spreadsheet

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. Shell Programming and Scripting

data for spreadsheet

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

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

9. UNIX for Beginners Questions & Answers

Converting text file to html page

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

10. Shell Programming and Scripting

Script Shell how's converting .html files

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

LEARN ABOUT CENTOS

sdl_joystickopen

SDL_JoystickOpen(3)						 SDL API Reference					       SDL_JoystickOpen(3)

NAME

       SDL_JoystickOpen - Opens a joystick for use.

SYNOPSIS

       #include "SDL.h"

       SDL_Joystick *SDL_JoystickOpen(int index);

DESCRIPTION

       Opens a joystick for use within SDL. The index refers to the N'th joystick in the system. A joystick must be opened before it game be used.

RETURN VALUE

       Returns a SDL_Joystick structure on success. NULL on failure.

EXAMPLES

       SDL_Joystick *joy;
       // Check for joystick
       if(SDL_NumJoysticks()>0){
	 // Open joystick
	 joy=SDL_JoystickOpen(0);

	 if(joy)
	 {
	   printf("Opened Joystick 0
       ");
	   printf("Name: %s
       ", SDL_JoystickName(0));
	   printf("Number of Axes: %d
       ", SDL_JoystickNumAxes(joy));
	   printf("Number of Buttons: %d
       ", SDL_JoystickNumButtons(joy));
	   printf("Number of Balls: %d
       ", SDL_JoystickNumBalls(joy));
	 }
	 else
	   printf("Couldn't open Joystick 0
       ");

	 // Close if opened
	 if(SDL_JoystickOpened(0))
	   SDL_JoystickClose(joy);
       }

SEE ALSO

       SDL_JoystickClose

SDL
							      Tue 11 Sep 2001, 23:00					       SDL_JoystickOpen(3)

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Converting HTML to CSV

Discussion started by: Jexel

2. Shell Programming and Scripting

Converting Shell Script to HTML

Discussion started by: davwel

3. Shell Programming and Scripting

Converting a text file to HTML

Discussion started by: ph0enix

4. Shell Programming and Scripting

Converting html to pdf perl

Discussion started by: DILEEP410