05-14-2009
joining files with different rows and colum
Hi all,
I have two files:
file one (9 rows, 3 columns):
A 1 x1
B 2 f1
C 3 f3
D 4 u5
E 5 l9
F 6 h6
G 7 g4
H 8 r4
I 9 s2
file two (4 rows, 1 column):
A
B
C
D
and I want output like this (4 rows, 3 columns):
file3:
A 1 x1
B 2 f1
C 3 f3
D 4 u5
Is there a way to do that, by using join or awk? When the rows are more than in those files, but still have 3 columns in file1 and 1 column in file2, how to do that? Tx
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Hi,
I have two files that I need to find difference between. Do I use diff or join? If join, how do I use it?
thanks,
webtekie (1 Reply)
Discussion started by: webtekie
1 Replies
2. UNIX for Dummies Questions & Answers
Hi,
Could anyone help me ?
I'm trying to join two files, but no common field are on them. So I think on generate \000\ sequence to add for each line on both files, so then will be able to join these files.
Any idea?
Thanks in advance, (2 Replies)
Discussion started by: Manu
2 Replies
3. Shell Programming and Scripting
Greetings, all. I've got a project that requires I join two data files together, then do some processing and output. Everything must be done in a shell script, using standard unix tools. The files look like the following:
File_1
Layout:
Acct#,Subacct#,Descrip
Sample:
... (3 Replies)
Discussion started by: rjlohman
3 Replies
4. Shell Programming and Scripting
I have many text file reports generated by a Information Assurance tool that I need to get into a .CSV format or Excel tab delimited format. I want to use sed or awk to grab all the information in the sample text file below and create column headings:Risk ID, Risk Level, Category, Description, How... (5 Replies)
Discussion started by: Bjoeboo
5 Replies
5. Shell Programming and Scripting
Hi Guys,
I need help in modifying a large text file containing more than 1-2 lakh rows of data using unix commands. I am quite new to the unix language
the text file contains data in a pipe delimited format
sdfsdfs
sdfsdfsd
START_ROW
sdfsd|sdfsdfsd|sdfsdfasdf|sdfsadf|sdfasdf... (9 Replies)
Discussion started by: manish2009
9 Replies
6. Shell Programming and Scripting
i have three files
file a has contents
123
234
238
file b has contents
189
567
567
and file c has contents
qwe
ert
ery (1 Reply)
Discussion started by: tomjones
1 Replies
7. UNIX for Dummies Questions & Answers
I have two comma separated files.
I want to join those filesa nd put the result in separate file.
smaple data are:
file1:
A1,1,100
A2,1,200
B1,2,100
B2,2,200
file2
1,50
1,25
1,25
1,100
1,100
2,50
2,50 (10 Replies)
Discussion started by: pandeesh
10 Replies
8. Shell Programming and Scripting
Hi,
I have about 20 tab delimited text files that have non sequential numbering such as:
UCD2.summary.txt
UCD45.summary.txt
UCD56.summery.txt
The first column of each file has the same number of lines and content. The next 2 column have data points:
i.e UCD2.summary.txt:
a 8.9 ... (8 Replies)
Discussion started by: rrdavis
8 Replies
9. Shell Programming and Scripting
File "A" (column names: Nickname Number GB)
Nickname Number GB
PROD_DB0034 100A 16
ASMIL1B_DATA_003 100B 16
PSPROD_0000 1014 36
PSPROD_0001 100D 223
.....
File "B" (column names: TYPE DEVICE NUMBER SIZE)
TYPE DEVICE NUMBER SIZE
1750500 hdisk2 100A 16384
1750500 hdisk3 ... (4 Replies)
Discussion started by: Daniel Gate
4 Replies
10. Shell Programming and Scripting
I have two files with the below contents :
sampleoutput3.txt
20150202;hostname1
20150223;hostname2
20150716;hostname3
sampleoutput1.txt
hostname;packages_out_of_date;errata_out_of_date;
hostname1;11;0;
hostnamea;12;0;
hostnameb;11;0;
hostnamec;95;38;
hostnamed;440;358;... (2 Replies)
Discussion started by: rahul2662
2 Replies
comm(1) User Commands comm(1)
NAME
comm - select or reject lines common to two files
SYNOPSIS
comm [-123] file1 file2
DESCRIPTION
The comm utility reads file1 and file2, which must be ordered in the current collating sequence, and produces three text columns as output:
lines only in file1; lines only in file2; and lines in both files.
If the input files were ordered according to the collating sequence of the current locale, the lines written will be in the collating
sequence of the original lines. If not, the results are unspecified.
OPTIONS
The following options are supported:
-1 Suppresses the output column of lines unique to file1.
-2 Suppresses the output column of lines unique to file2.
-3 Suppresses the output column of lines duplicated in file1 and file2.
OPERANDS
The following operands are supported:
file1 A path name of the first file to be compared. If file1 is -, the standard input is used.
file2 A path name of the second file to be compared. If file2 is -, the standard input is used.
USAGE
See largefile(5) for the description of the behavior of comm when encountering files greater than or equal to 2 Gbyte ( 2**31 bytes).
EXAMPLES
Example 1: Printing a list of utilities specified by files
If file1, file2, and file3 each contain a sorted list of utilities, the command
example% comm -23 file1 file2 | comm -23 - file3
prints a list of utilities in file1 not specified by either of the other files. The entry:
example% comm -12 file1 file2 | comm -12 - file3
prints a list of utilities specified by all three files. And the entry:
example% comm -12 file2 file3 | comm -23 -file1
prints a list of utilities specified by both file2 and file3, but not specified in file1.
ENVIRONMENT VARIABLES
See environ(5) for descriptions of the following environment variables that affect the execution of comm: LANG, LC_ALL, LC_COLLATE,
LC_CTYPE, LC_MESSAGES, and NLSPATH.
EXIT STATUS
The following exit values are returned:
0 All input files were successfully output as specified.
>0 An error occurred.
ATTRIBUTES
See attributes(5) for descriptions of the following attributes:
+-----------------------------+-----------------------------+
| ATTRIBUTE TYPE | ATTRIBUTE VALUE |
+-----------------------------+-----------------------------+
|Availability |SUNWesu |
+-----------------------------+-----------------------------+
|CSI |enabled |
+-----------------------------+-----------------------------+
|Interface Stability |Standard |
+-----------------------------+-----------------------------+
SEE ALSO
cmp(1), diff(1), sort(1), uniq(1), attributes(5), environ(5), largefile(5), standards(5)
SunOS 5.10 3 Mar 2004 comm(1)