Hi All,
I have a table with 10 columns. Some columns(2nd,4th,5th,7th,8th and 10th) are Not Null columns. I'll get a tab-delimited file and want to check col by col and generate seperate error code for each col eg:102 if 2nd col value is NULL and 104 if 4th col value is NULL so on... I am a... (7 Replies)
Hi All,
I have a file which is having 3 columns as (string string integer)
a b 1
x y 2
p k 5
y y 4
.....
.....
Question:
I want get the unique value of column 2 in a sorted way(on column 2) and the sum of the 3rd column of the corresponding rows. e.g the above file should return the... (6 Replies)
Hi, my requirement is to sum values in a row.
eg:
input is: sum,value1,value2,value3,.....,value N
Required Output: sum,<summation of N values>
Please help me... (5 Replies)
Hi All,
I have two sets of files.
Set 1: 100 text files with extension .txt with names like 1.txt, 2.txt, 3.txt until 100.txt
Set 2: One big file with extension .dat
The text files have some records in columns like this:
0.7316431 82628
0.7248189 82577
0.7248182 81369
0.7222999... (1 Reply)
I want to get count on number of records in a few folders by running grep command for more than two columns in a row of fixed length file.
suppose if i have a fixed length file has 5 columns and I want to see the record counts for country =can and province = bc and time stamp <= 12 feb 2013... (14 Replies)
Hi would like to ask you guys any advise regarding my problem
I have this kind of data
file.txt
111111111,20
111111111,50
222222222,70
333333333,40
444444444,10
444444444,20
I need to get this
file1.txt
111111111,70
222222222,70
333333333,40
444444444,30
using this code I can... (6 Replies)
Hi,
I am a new bie i need some help with respect to shell onliner;
I have data in following format
Name FromDate UntilDate Active Changed Touched
Test 28-03-2013 28-03-2013 1 0.6667 100
Test2 28-03-2013 03-04-2013 ... (1 Reply)
I have a file (let say file B) like this:
File B:
A1 3 5
A1 7 9
A2 2 5
A3 1 3
The first column defines a filename and the other two define a range in that specific file. In the same directory, I have also three more files (File A1, A2 and A3). Here is 10 sample lines... (3 Replies)
Hi Experts,
Please bear with me, i need help
I am learning AWk and stuck up in one issue.
First point : I want to sum up column value for column 7, 9, 11,13 and column15 if rows in column 5 are duplicates.No action to be taken for rows where value in column 5 is unique.
Second point : For... (12 Replies)
Discussion started by: as7951
12 Replies
LEARN ABOUT ULTRIX
tbl
tbl(1) General Commands Manual tbl(1)Name
tbl - format tables for nroff or *roff
Syntax
tbl [files...]
Description
The preprocessor is used for formatting tables for or The input files are copied to the standard output, except for lines between .TS and
.TE command lines, which are assumed to describe tables and are reformatted.
Options-TX Produces output without fractional line motions. Use when the destination output device or printer or post-filter cannot handle
fractional line motions.
-ms Reads in macros prior to table formatting.
-mm Reads in the macros prior to table formatting, if your system has the macros installed.
Examples
As an example, letting represent a tab (which should be typed as a genuine tab) the input
.TS
c s s
c c s
c c c
l n n.
Household Population
Town Households
Number Size
Bedminster 789 3.26
Bernards Twp. 3087 3.74
Bernardsville 2018 3.30
Bound Brook 3425 3.04
Branchburg 1644 3.49
Bridgewater 7897 3.81
Far Hills 240 3.19
.TE
yields
Household Population
Town Households
Number Size
Bedminster 789 3.26
Bernards Twp. 3087 3.74
Bernardsville 2018 3.30
Bound Brook 3425 3.04
Branchburg 1644 3.49
Bridgewater 7897 3.81
Far Hills 240 3.19
If no arguments are given, reads the standard input, so it may be used as a filter. When is used with or the command should be first, to
minimize the volume of data passed through pipes.
See Alsonroff(1)
"Tbl - A Program to Format Tables," ULTRIX Supplementary Documents, Vol. I:General User
tbl(1)