11-22-2012
Quote:
Originally Posted by
b@l@ji
Hi,
I need help in following two tasks.
Tasks:1 Column comparison between two files.
There is a file_1 with columns $1 , $2 , $3 , $4 , $5
Another is file_2 with columns $1 , $2 , $3 , $4 , $5
1.) i wish to compare whether values in $2 in file_1 is equal to $3 in file_2 and $3 in file_1 is equal to $5 in file_2
2.) i wish to replace the column $1 in file_2 using the values in the column $5 from file_1
Tasks:2 How to add extra lines to an existing file ?
for example, i want to add following two lines to an existing file at bottom. Is it possible to do it, without having to write the below two lines into a separate file and use "cat" command ?
Numbers
5678
This sounds like a homework item; if it is it shouldn't be posted here.
If this isn't a homework item, what is supposed to happen if the values are equal and what is supposed to happen if they are not equal?
Yes, it is possible to add lines to the end of a file without using cat.
If you want help figuring out how to do something, you will be much more likely to get useful results if you provide sample input files and show us the output that should be produced (all using code tags).
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi Gurus,
In my file I have an amount field from position 74 to 87, which contains values starting with '+' as well as '-'. I want to add all positive values in a varible called "CREDIT" and all negative values in a variable "DEBIT". I know, we can use grep to identify values with positive and... (4 Replies)
Discussion started by: berlin_germany
4 Replies
2. IP Networking
In my college dorm, there is a file sharing network in the entire building. Problem is, there is only a manual for windows with the settings on how to connect... :mad:
They say that you have to give the following command in cmd in windows:
route add 172.16.71.0 mask 255.255.255.0... (2 Replies)
Discussion started by: Japie89
2 Replies
3. Shell Programming and Scripting
I have two files as follows:
Pval.txt
ID Pvalue
91500 0.004
91700 0.007
91800 0.12
91900 0.05
92000 0.99
Freq.txt
ID Frequency
90000 56
91500 29
91600 78
91700 60
91800 77
91900 66
92000 70
92100 50
92200 60I need to compare 1st... (19 Replies)
Discussion started by: cs_novice
19 Replies
4. Solaris
Hi Solaris users - I have an Ultra10 SPARC machine, with IIe processor. To prepare for the Solaris10 admin exam PartII I need to set up the metadb/mirroring in my machine, but do not know how to do this properly.
I need this to practice the mirroring tasks.
If anyone could help it would be... (3 Replies)
Discussion started by: patcom
3 Replies
5. Shell Programming and Scripting
Hi, I need to add a column of unique string to individual csv file.
my individual csv file looks like this and each file has variable row length:
178.52,39.4,train,0.003355544375334351,39.15752753933254,0.4895933968953914... (7 Replies)
Discussion started by: ida1215
7 Replies
6. Shell Programming and Scripting
Hello,
I was wondering if anyone knows a faster way to search and compare strings and dates from 2 files?
I'm currently using "for loop" but seems sluggish as i have to cycle through 10 directories with 10 files each containing thousands of lines.
Given:
-10 directories
-10 files... (4 Replies)
Discussion started by: agentgrecko
4 Replies
7. Shell Programming and Scripting
Hi All,
I have two files having oracle query result. I want to merge to files line by line and also with column
File1
23577|SYNC TYPE
23578|Order Number|ConnectionState
23585|Service State|Service NameFile2
23577|AR Alarm Sync
23578|A5499|9
23585|7|test_nov7Result... (18 Replies)
Discussion started by: Harshal22
18 Replies
8. Shell Programming and Scripting
HI Guys,
I have below input.
Output Base on Below Condition.
1> if forth column is empty and next coming line have same name with \es then add that column name on all rows
2>rest of all are es:vsDataEUtranCellFDD
Input:-
CCL01736 CCL01736_7A_1 es:vsDataEUtranCellFDD ... (3 Replies)
Discussion started by: pareshkp
3 Replies
9. Shell Programming and Scripting
Greetings Experts,
I need to handle the views created over monthly retention tables
for which every new table in YYYYMMDD format, there is
equivalent view created and the older table which might be
dropped, the view over it has to be re-created over a dummy
table so that it doesn't fail.... (2 Replies)
Discussion started by: chill3chee
2 Replies
10. Shell Programming and Scripting
Hi All,
I have a file with only one column of data (without delimiter). For Ex:
cat temp.txt
22055
21088
93840
30990
50990
50950
I want to insert an additional column with current date as value. So, i have used below command but didn't get the result as excepted. Could onyone over... (5 Replies)
Discussion started by: Suresh
5 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)