Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Need help shell+awk+html
Top Forums Shell Programming and Scripting Need help shell+awk+html Post 302578742 by ygemici on Friday 2nd of December 2011 08:15:25 AM
Old 12-02-2011
Quote:
Originally Posted by vasil
Hi ygemici
Below is the output from the command
Code:
[user@OMCTC cdr_TC]$ /bin/zcat /CDR/cdr_TC/callogs*_*_20111201*.gz |sed 's/[:]/;/g' |awk -F";" '{if($1~/1/ && $2~/1/) print $0}' | more

1146D92DF    1    4
1146DF29F    1    2
11484C213    1    2
11484C214    1    4
1146DF2A0    1    2
11484C213    1    2
1146E489A    1    4
1146D92E2    1    2
11484C215    1    4
11484C216    1    2
11484C218    1    4
1146D92E1    1    2
11484C219    1    2
11484C21A    1    2
1146DF2A7    1    2
11484C21B    1    2
11484C21B    1    2
1146E489F    1    2
11484C21C    1    2

try change BEGIN portion with this
Code:
'BEGIN{printf "%s\n%s\n%s\n%s\n%s\n","<table>","<tr>","<th>msgid</th>","<th>origpdu</th>","</tr>"}'

so like this
Code:
'BEGIN{printf "%s\n%s\n%s\n%s\n%s\n","<table>","<tr>","<th>msgid</th>","<th>origpdu</th>","</tr>"}
{for(i=1;i<=NF;i++)printf "%s\n%s%s%s\n%s\n","<tr>","<td>",$i,"</td>","</tr>"}'

Last edited by ygemici; 12-02-2011 at 09:23 AM..
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

SHELL SCRIPT AND HTML

Hello I'm trying to develop a shell script that executes commands such as cat / etc / fstab uname, etc. ..... which generates me an output file format html own way. Currently the shell script with the commands there, I have some notions of html but the generation of my html file is not clean at... (2 Replies)
Discussion started by: ddtseb
2 Replies

2. Shell Programming and Scripting

html formatting using awk

Hi I have a file as given below: <table border=1> <TR><TH>Script Name</TH><TH>CVS Status</TH><TH>Script Location</TH></TR> <TR><TD><CENTER>Work Area: /home/ustst/</CENTER></TD></TR> <TR><TD><CENTER>admin_export.sh</CENTER></TD><TD><CENTER>Locally... (1 Reply)
Discussion started by: sudvishw
1 Replies

3. Shell Programming and Scripting

awk help for HTML

Hi all, I have a file as below input.csv NAME,EMPNO,PHNO kkk,1234,0000 nnn,456,8765 hhh,888,555 hhy,222,567 i want to convert this into HTML table im using this awk -F"," 'BEGIN{print "<table border=1>" { print "<tr>";for(i=1;i<=NF;i++)print "<td><b><font face=\"verdana\"><font... (1 Reply)
Discussion started by: zozoo
1 Replies

4. Shell Programming and Scripting

awk to parse html file

Is it possible in awk to parse a webpage (EDAR Gene Sequencing - Genetic Testing Company | The DNA Diagnostic Experts | GeneDx), the source code is attached. <title> EDAR Gene Sequencing <dt>Test Code:</dt> <dd>156 </dd> <dt>Turnaround Time:</dt> <dd>6-8 weeks </dd> ... (4 Replies)
Discussion started by: cmccabe
4 Replies

5. Shell Programming and Scripting

Help in using html in Shell script

Hi, I made a script that displays various fileds of report that are required in csv format and send it on mail(the csv file). Now I want to convert the csv format into html table and then send it on mail. Reports_Output.csv Code:... (6 Replies)
Discussion started by: Supriya Singh
6 Replies

6. Shell Programming and Scripting

Awk/sed HTML extract

I'm extracting text between table tags in HTML <th><a href="/wiki/Buick_LeSabre" title="Buick LeSabre">Buick LeSabre</a></th> using this: awk -F "</*th>" '/<\/*th>/ {print $2}' auto2 > auto3 then this (text between a href): sed -e 's/\(<*>\)//g' auto3 > auto4 How to shorten this into one... (8 Replies)
Discussion started by: p1ne
8 Replies

7. Shell Programming and Scripting

Help with awk and html

Hi i have a file say test with the following output server share-name path acl ---------- ----------------------------... (2 Replies)
Discussion started by: venkitesh
2 Replies

8. UNIX for Beginners Questions & Answers

awk HTML Conditional Formating

I am receiving the below output in text format. The output is converted to HTML table using the code mentioned below output in text LogDate DayOfWeek/Hours _0_ _1_ _2_ _3_ _4_ _5_ _6_ _7_ _8_ _9_ _10_ _11_ _12_ _13_ _14_ _15_ _16_ ... (3 Replies)
Discussion started by: Dumpi16
3 Replies

9. UNIX for Beginners Questions & Answers

Html output with awk/sendmail

Hello All, I inherited maintenance of a script that uses awk on an input file (space delimited) and formats it into an html table and send out using sendmail. I know how to manipulate the print statements to add columns and rows, however that is the extent of my html knowlege. I've searched... (5 Replies)
Discussion started by: Big-J
5 Replies

10. UNIX for Beginners Questions & Answers

awk to extract value after keyword in html

Using awk to extract value after a keyword in an html, and store in ts. The awk does execute but ts is empty. I use the tag as a delimiter and the keyword as a pattern, but there probably is a better way. Thank you :). file <html><head><title>xxxxxx xxxxx</title><style type="text/css"> ... (4 Replies)
Discussion started by: cmccabe
4 Replies

LEARN ABOUT DEBIAN

shcomp

SHCOMP(1)						    User Environment Utilities							 SHCOMP(1)

NAME

       shcomp - compile a ksh93 shell script

SYNOPSIS

       shcomp [ options ] [infile] [outfile]]

ORIGIN OF THIS MAN PAGE

       This man page was written by Christophe Martin <Schplurtz@free.fr> for the Debian GNU/Linux system. It is based on "shcomp --man" output.

DESCRIPTION

       Unless  -D  is  specified,  shcomp takes a shell script, infile, and creates a binary format file, outfile, that ksh93 can read and execute
       with the same effect as the original script.

       Since aliases are processed as the script is read, alias definitions whose value requires variable expansion will not work correctly.

       If -D is specified, all double quoted strings that are preceded by $ are output. These are the messages	that  need  to	be  translated	to
       locale specific versions for internationalization.

       If  outfile is omitted, then the results will be written to standard output.  If infile is also omitted, the shell script will be read from
       standard input.

OPTIONS

       -D, --dictionary
	      Generate a list of strings that need to be placed in a message catalog for internationalization.

       -n, --noexec
	      Displays warning messages for obsolete or non-conforming constructs.

       -v, --verbose
	      Displays input from infile onto standard error as it reads it.

       --man  Displays this man page on standard error and exits.

       --help Shows a short help message and exits.

EXIT STATUS

       0      Successful completion.

       >0     An error occurred.

DEBIAN WARNING

       On a Debian GNU/Linux system, more than one package may provide ksh. the output of shcomp can only be used by ksh93.  Any other ksh will be
       unable to run the compiled script.

EXAMPLE

       ( echo '#! /bin/ksh93' ; shcomp myscript ) > myscript.bin &&
       chmod 755 myscript.bin
       ./myscript.bin

SEE ALSO

       ksh(1)

IMPLEMENTATION

       version	       shcomp (AT&T Labs Research) 2012-02-29
       author	       David Korn <dgk@research.att.com>
       copyright       Copyright (c) 1982-2012 AT&T Intellectual Property
       license	       http://www.eclipse.org/org/documents/epl-v10.html

KSH93								  Fri Jun 3 2005							 SHCOMP(1)
All times are GMT -4. The time now is 03:34 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy