05-19-2013
You don't need comm nor multiple sort commands. Just one sort with both files as arguments whose output is piped directly into awk.
Within awk, you would have to track the value of the last field, $NF, to determine when to generate the missing lines.
Regards,
Alister
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Here is what I am trying to do:
I have a list of numbers that I pulled from an awk command in a column like so:
1
3
4
7
8
I want to find which numbers in the list are missing out of a range. So let's say I want to find out from the list above which numbers are missing from the... (6 Replies)
Discussion started by: afavis
6 Replies
2. Shell Programming and Scripting
Hi All,
I am trying to cut to do a cut operation, but since there are seems to be more than one deltimiters in some occasion I am not able to get the exact field. Can you please provide an SED and AWK script for treating the source file in such a way that all consecutive delimiters are treated... (3 Replies)
Discussion started by: rakesh.su30
3 Replies
3. Shell Programming and Scripting
sample file (comma as field separators)
MessageFlow,1,BusIntBatchMgr,a
OOBEvent,1,BusIntBatchMgr,a
TaskEvents,1,,a
MTTrace,1,,a
MTWarning,,1,a
MessageFlow,1,Batch,a
OOBEvent,1,Batch,a
TaskEvents,1,,a
EAISAPIdocWizard,1,BusIntMgr,a
EAISAPBAPIWizard,1,BusIntMgr,a... (3 Replies)
Discussion started by: vrclm
3 Replies
4. Shell Programming and Scripting
Hi,
I have an input file of the following style
input.txt
The 4000 at the end indicates the total no. of columns in that row.
I would like to replace all -1s with consecutive 1 and 2 and print the whole line again.
So, the output would be
output.txt
Thanks in advance. (7 Replies)
Discussion started by: jacobs.smith
7 Replies
5. Shell Programming and Scripting
I do have a tab delimited file with the following format
200 46
201 67
204 89
205 98
206 89
208 890
210 23
..
...
100's of rows
I would like to output the missing consecutive number of the first column.
The expected output will be: (1 Reply)
Discussion started by: Lucky Ali
1 Replies
6. Shell Programming and Scripting
Dear All,
I have a file which is as follows:
Input File:
231 100.1
233 99
235 200.9
238 80.1
239 90.2
240 77.0
243 99.5
245 16.20
246 13.55
247 11.8
249 13.7
250 99.6 (1 Reply)
Discussion started by: NamS
1 Replies
7. Shell Programming and Scripting
Hello to all,
I have show below a file separated by commas. In first column has numbers where the last number is 13.
1,4
2,6
3,7
5,2
6,5
7,5
8,65
9,10
11,78
13,2
What I want to know is which numbers are missing from 1 to 13 (in this case 13 is last number in column 1). My real... (17 Replies)
Discussion started by: Ophiuchus
17 Replies
8. UNIX for Dummies Questions & Answers
Dear All,
I have a file with only one column. And I want to add every 3 consecutive numbers together and print the result.
Input File:
21.1
10
10
55
11
99
10
8
4
Expected Output:
41.1 (5 Replies)
Discussion started by: NamS
5 Replies
9. Shell Programming and Scripting
Using the file below, which will always have the first indicated by the digit after the -
and last id in it, indicated by the digit after the -, I am trying to use awk
to print the missing line or lines in file following the pattern of the previous line.
For example, in the file below the next... (4 Replies)
Discussion started by: cmccabe
4 Replies
10. Shell Programming and Scripting
Hi,
In an ideal scenario, I will have a listing of db transaction log that gets copied to a DR site and if I have them all, they will be numbered consecutively like below.
1_79811_01234567.arc
1_79812_01234567.arc
1_79813_01234567.arc
1_79814_01234567.arc
1_79815_01234567.arc... (3 Replies)
Discussion started by: newbie_01
3 Replies
JOIN(1) General Commands Manual JOIN(1)
NAME
join - relational database operator
SYNOPSIS
join [ options ] file1 file2
DESCRIPTION
Join forms, on the standard output, a join of the two relations specified by the lines of file1 and file2. If file1 is `-', the standard
input is used.
File1 and file2 must be sorted in increasing ASCII collating sequence on the fields on which they are to be joined, normally the first in
each line.
There is one line in the output for each pair of lines in file1 and file2 that have identical join fields. The output line normally con-
sists of the common field, then the rest of the line from file1, then the rest of the line from file2.
Fields are normally separated by blank, tab or newline. In this case, multiple separators count as one, and leading separators are dis-
carded.
These options are recognized:
-an In addition to the normal output, produce a line for each unpairable line in file n, where n is 1 or 2.
-e s Replace empty output fields by string s.
-jn m Join on the mth field of file n. If n is missing, use the mth field in each file.
-o list
Each output line comprises the fields specified in list, each element of which has the form n.m, where n is a file number and m is a
field number.
-tc Use character c as a separator (tab character). Every appearance of c in a line is significant.
SEE ALSO
sort(1), comm(1), awk(1)
BUGS
With default field separation, the collating sequence is that of sort -b; with -t, the sequence is that of a plain sort.
The conventions of join, sort, comm, uniq, look and awk(1) are wildly incongruous.
7th Edition April 29, 1985 JOIN(1)