05-02-2012
hey rbatte1,
Yes, you have been beaten. This data is tab separated, delimited by \n. The basic idea here is that in file1, you have a list of records that are acceptable users that have posted something - the 6th (or 5th, see my above post) column is one user id (this is a tweet, folks), and the final column is another user id. Ideally, we would collect all data points where 6th is not empty and 18th is in the list, I figured this was a halfway-step towards that?
---------- Post updated at 11:59 AM ---------- Previous update was at 11:55 AM ----------
Ahh, ok! So Scrutinizer, that will give us a result where either user id is included in file 1; in this case, just changing over to && will make it perform the intended action. A final question: how can you uniq this output in the event where a line matches twice? just uniq?
10 More Discussions You Might Find Interesting
1. UNIX for Advanced & Expert Users
Dear all,
I have two files in UNIX File1 and File2 as below:
File1:
1,1234,.,67.897,,0
1,4134,.,87.97,,4
0,1564,.,97.8,,1
File2:
2,8798,.,67.897,,0
2,8879,.,77.97,,4
0,1564,.,97.8,,1
I want to do the following:
(1) Make sure that both the files have equal number of columns and if... (1 Reply)
Discussion started by: ggopal
1 Replies
2. Shell Programming and Scripting
Dear all,
I have two files in UNIX File1 and File2 as below:
File1:
1,1234,.,67.897,,0
1,4134,.,87.97,,4
0,1564,.,97.8,,1
File2:
2,8798,.,67.897,,0
2,8879,.,77.97,,4
0,1564,.,97.8,,1
I want to do the following:
(1) Make sure that both the files have equal number of columns and if... (4 Replies)
Discussion started by: ggopal
4 Replies
3. Shell Programming and Scripting
Hey all,
So I have this challenge where I am attempting to compare record counts from within several different log files. I want input and output counts for each file, and I want to compare that with the result of the input/output comparison from a separate--but related file.
Example:
... (2 Replies)
Discussion started by: gator76
2 Replies
4. UNIX for Dummies Questions & Answers
Hi,
I have two files with the same number of columns. Basically I want to print the 2 columns that match between the two files.
File1 looks like this:
dr12 12 6 abn
dr14 12 7 abn
File2 looks something like this:
dr12 12 8 abn
dr12 14 7 abn
So basically if the first... (1 Reply)
Discussion started by: kylle345
1 Replies
5. UNIX for Dummies Questions & Answers
Hi,
I have two files. File1.txt has 2 columns and looks like:
458739 122345
4456 122657
34200 122600
File2.txt has many columns with column 1 the same as column2 of File1.txt, but with lot more rows:
122786 abcdefg user1@email
122778 uuhjeufh user2@email... (1 Reply)
Discussion started by: ursaan
1 Replies
6. Shell Programming and Scripting
Hello,
I have two files as 1.txt and 2.txt with number as columns.
1.txt
0 53.7988
1 -30.0859
2 20.1632
3 14.2135
4 14.6366
5 -37.6258
.
.
.
31608 -8.57333
31609 -2.58554
31610 -24.2857
2.txt (1 Reply)
Discussion started by: AKD
1 Replies
7. Shell Programming and Scripting
Hi,
I have a single-column file1 having records like:
00AB01/11
43TG22/00
78RC09/34
......
......
and a second file , file 2 having two columns like
78RC09/34 1
45FD11/11 2
00AB01/11 3
43TG22/00 4
......
...... (8 Replies)
Discussion started by: amarn
8 Replies
8. UNIX for Dummies Questions & Answers
Hi,
I have a file like this:
abc
def
ghi
jkl
mno
My second file is like this (tab delimited):
adsad sdfsdf dfdf
wads abc dfdsf
sdsf jkl sfsdf
dsfds sdfd reor
zxczd dsf sff
Now, I want the code to report the lines (from file2) which have common strings in column 2 with the first... (4 Replies)
Discussion started by: a_bahreini
4 Replies
9. Shell Programming and Scripting
Hi
I have large text file consisting of five columns. Sample of the file is give below:
ed 2-4 12.0 commons that they depended on. मानवों नष्ट किया जिन पर वो आधारित थे।
ed 3-1 12.0 Almost E, but would be over. रचना करीब करीब ई तक जाती है, मगर तब तो नाटक ख़त्म हो... (2 Replies)
Discussion started by: my_Perl
2 Replies
10. UNIX for Beginners Questions & Answers
Hi,
I'm trying to copy and paste the sixth column from a bunch of files into a single file having each column pasted in separate columns (and not one after each other in just one column.)
I tried this code but works only partially because it copied and pasted 50 rows of each column... (6 Replies)
Discussion started by: Frastra
6 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)