Sponsored Content
Top Forums Shell Programming and Scripting Create table using tbl command Post 302636617 by drl on Monday 7th of May 2012 05:14:21 PM
Old 05-07-2012
Hi.

The code in the earlier script was designed to process the first parameter as the file containing the tbl markup. This is more specific and uses ksh (which for this purpose is not critical):
Code:
#!/usr/bin/env ksh

# @(#) s3	Demonstrate table generation with tbl.

pe() { for _i;do printf "%s" "$_i";done; printf "\n"; }
pl() { pe;pe "-----" ;pe "$*"; }
db() { ( printf " db, ";for _i;do printf "%s" "$_i";done;printf "\n" ) >&2 ; }
db() { : ; }
C=$HOME/bin/context && [ -f $C ] && . $C tbl groff


pl " Input file t1:"
cat t1

pl " Results:"
tbl t1 |
groff -T ascii

exit 0

producing:
Code:
% ./s3

Environment: LC_ALL = C, LANG = C
(Versions displayed with local utility "version")
OS, ker|rel, machine: Linux, 2.6.26-2-amd64, x86_64
Distribution        : Debian GNU/Linux 5.0.8 (lenny) 
ksh 93s+
tbl GNU tbl (groff) version 1.18.1
groff GNU groff version 1.18.1

-----
 Input file t1:
.TS
tab(;) allbox;
c s s s
l l l l.
PO Download statistics - Host to SOM
Time;Receive Time;Processing Time;PO count
4.30 AM OMHPO File;Tue Feb 21 04:39:55 EST 2012;Tue Feb 21 05:38:58 EST 2012;17508
.TE

-----
 Results:
grotty:t1:7: character above first line discarded
+--------------------------------------------------------------------------------------------+
|                           PO Download statistics - Host to SOM                             |
+-------------------+------------------------------+------------------------------+----------+
|Time               | Receive Time                 | Processing Time              | PO count |
+-------------------+------------------------------+------------------------------+----------+
|4.30 AM OMHPO File | Tue Feb 21 04:39:55 EST 2012 | Tue Feb 21 05:38:58 EST 2012 | 17508    |
+-------------------+------------------------------+------------------------------+----------+

Best wishes ... cheers, drl
This User Gave Thanks to drl For This Post:
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

create new table/field

Dear Folks, If I have 2 files, say A and B in format: A: $1 $2 01032 12856 01041 13351 01042 11071 01042 12854 01042 12862 01042 12866 . . . and B: (2 Replies)
Discussion started by: Gr4wk
2 Replies

2. Shell Programming and Scripting

[ORACLE] CREATE TABLE in bash

Hey, I want to create a table in bash, my db server is oracle. You can find my script below: I am very confused. I tried to run this script many times without any luck. Please help! (6 Replies)
Discussion started by: radek
6 Replies

3. Shell Programming and Scripting

How to create a C structure using table description.

There is table 'DEPT' in the database with the following desciption: Name Null? Type ------- -------- ------------------------ DEPTNO NOT NULL NUMBER(2) DNAME NULL VARCHAR2(14) LOC NULL VARCHAR2(13) Using shell script, I need to create a structure for the... (2 Replies)
Discussion started by: ehari
2 Replies

4. Shell Programming and Scripting

to create an output file as a table

Hi, I have four input files and would like to create an output file as a table. Please check the example below. File 1. 111111 222222 333333 444444 File 2. 555555 666666 777777 888888 File 3. aaaaa bbbbb ccccc ddddd (2 Replies)
Discussion started by: marcelus
2 Replies

5. Shell Programming and Scripting

Create table

Hi I want create table based on csv file .I have come up with some informations getting columns names and then no idea from that .Please any help file.txt col1|col2|col3|col4|col5 1234|zxxxx|xcvvv|300|null file.sh file=$1 c1=`head -1 $file|tr "|" "\n" |cat -n` echo "$c1"... (31 Replies)
Discussion started by: mohan705
31 Replies

6. UNIX for Dummies Questions & Answers

Create a table - very new to unix

I need to create a simple table of information by grepping several columns from various files and display them all at once with simple headers on top. Can anyone help get me started? I am very new to unix so I really have no idea how to work with this and I appreciate any help I can get! Let me... (11 Replies)
Discussion started by: aj250
11 Replies

7. UNIX and Linux Applications

create table via stored procedure (passing the table name to it)

hi there, I am trying to create a stored procedure that i can pass the table name to and it will create a table with that name. but for some reason it creates with what i have defined as the variable name . In the case of the example below it creates a table called 'tname' for example ... (6 Replies)
Discussion started by: rethink
6 Replies

8. Shell Programming and Scripting

Create Pivot table

I would like to use awk to parse a file with three columns in, like: Chennai,01,1 Chennai,07,1 Chennai,08,3 Chennai,09,6 Chennai,10,12 Chennai,11,19 Chennai,12,10 Chennai,13,12 Kerala,09,2 AP,10,1 AP,11,1 Delhi,13,1 Kerala,13,3 Chennai,00,3 Chennai,01,1 Chennai,02,1 Chennai,07,5 (3 Replies)
Discussion started by: boston_nilesh
3 Replies

9. Shell Programming and Scripting

Create Script from table

I have a table ABC with 4 columns and below data Col1,Col2,Col3,Col4 prod,10,12,joba prod,10,11,jobb qa,10,12,jobc I want to create an output file like this Server:prod StartTime:10 EndTime:12 JobName:joba Server:prod StartTime:10 EndTime:11 JobName:jobb (3 Replies)
Discussion started by: traininfa
3 Replies

10. Shell Programming and Scripting

Create table within awk-if statement

Hi I am trying to create a table within an awk if statement awk -F, '{ if ($8 ~ /Match/) BEGIN{print "<table>"} {print "<tr>";for(i=1;i<=NF;i++)print "<td>" $i"</td>";print "</tr>"} END{print "</table>"}' SN1.csv | mailx -s "Your details" abc@123.com But this doesnt work.. Please suggest (8 Replies)
Discussion started by: sidnow
8 Replies
MAN.CONF(5)							File Formats Manual						       MAN.CONF(5)

NAME
man.conf - configuration data for man DESCRIPTION
This file is read by man(1) and contains (a) information on how to construct the search path for man, (b) full path names for various pro- grams like nroff, eqn, tbl etc. used by man, and (c) a list with uncompressors for files with a given extension. An alternative version of this file can be specified with man -C private_man.conf ... The command names may be provided with options. Useful options to nroff can be found in grotty(1). For example, instead of the default line NROFF /usr/bin/groff -mandoc -Tlatin1 one may write NROFF /usr/bin/groff -mandoc -Tlatin1 -P-u -P-b in order to suppress underlining and overstriking. FILES
/private/etc/man.conf AUTHOR
John W. Eaton was the original author of man. Zeyd M. Ben-Halim released man 1.2, and Andries Brouwer followed up with versions 1.3 thru 1.5p. Federico Lucifredi <flucifredi@acm.org> is the current maintainer. SEE ALSO
col(1), (g)eqn(1), (g)pic(1), groff(1), grotty(1), (g)refer(1), (g)tbl(1), less(1), man (1) and compress(1), gzip(1). September 19, 2005 MAN.CONF(5)
All times are GMT -4. The time now is 07:28 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy