01-25-2013
Brilliant, both work a treat, thank you!
And I _think_ I follow what is going on, bonus!
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Hi,
I have a wide and long dataset which looks as follows:
0 3 4 2 3 0 2 2 ...
3 2 4 0 2 2 2 3 ...
0 3 4 2 0 4 4 4 ...
3 0 4 2 2 4 2 4 ...
....
I would like to obtain the minimum of each column (ignoring zero values) so the output would look like:
3 2 4 2 2 2 2 2
I have the... (3 Replies)
Discussion started by: kasan0
3 Replies
2. UNIX for Dummies Questions & Answers
Hi Everyone,
I was wondering if someone could help me to transform my data into a format I need.
Here is an example of what my data looks like
E F G H
A 1 2 3 4
B 5 6 7 8
C 9 1 2 3
D 4 5 6 7
and this is what I would need it to look like:
AE 1
BE 5
CE 9
DE 4
AF 2
BF 6
CF 1 (6 Replies)
Discussion started by: zajtat
6 Replies
3. Shell Programming and Scripting
Hi Friends,
I have the following file
chr1 1 2
chr1 2 3
chr1 3 4
chr1 4 5
chr1 5 6
chr1 19 20
chr1 20 21
chr1 21 22
I want to compare the third column of record 1 to second column of next record and if the difference is zero, consider its third column and match it to next record... (4 Replies)
Discussion started by: jacobs.smith
4 Replies
4. UNIX for Dummies Questions & Answers
Hi,
I have a tab delimited text file where the first two columns equal numbers. I want to delete all rows where the value in the first column equals the second column. How do I go about doing that? Thanks!
Input:
1 1 ABC DEF
2 2 IJK LMN
1 2 ZYX OPW
Output:
1 2 ZYX OPW (2 Replies)
Discussion started by: evelibertine
2 Replies
5. Shell Programming and Scripting
Hello,
I have two files as the following:
File1:
F0100020 A G
F0100030 A T
F0100040 A G
File2:
F0100040 A G BTA-28763-no-rs 77.2692
F0100030 A T BTA-29334-no-rs 11.4989
F0100020 A G BTA-29515-no-rs 127.006
I want to sort the second file based on the... (6 Replies)
Discussion started by: Homa
6 Replies
6. Shell Programming and Scripting
hello,
I have a file as follows:
F0100010 A C F0100040 A G BTA-28763-no-rs 77.2692
F0100020 A G F0100030 A T BTA-29334-no-rs 11.4989
F0100030 A T F0100020 A G BTA-29515-no-rs 127.006
F0100040 A G F0100010 A C BTA-29644-no-rs 7.29827
F0100050 A... (9 Replies)
Discussion started by: Homa
9 Replies
7. Shell Programming and Scripting
I have a file like this :
# cat list
cucm, location,76,2
cucm1,location1,76,4
cucm,location,80,8
cucm1,location1,90,8
cucm1,location1,87,11
cucm,location,67,9
and I want output like this :
cucm,location,76,2
cucm1,location1,76,4
cucm,location,80, 6 ===> (8-2 =6)
cucm1,location1,90,4... (5 Replies)
Discussion started by: Lakshmikumari
5 Replies
8. Shell Programming and Scripting
File 1:
20130416,235800,10.78.25.104,BR2-loc,60.0,1624,50.0,0,50.0,0
20130416,235800,10.78.25.104,BR1-LOC,70.0,10,50.0,0,70.0,0
20130416,235800,10.78.25.104,Hub_None,60.0,15,60.0,0,50.0,0
File 2:
20130417,000200,10.78.25.104,BR2-loc,60.0,1626,50.0,0,50.0,0... (3 Replies)
Discussion started by: Lakshmikumari
3 Replies
9. Shell Programming and Scripting
This is my input file :
# cat list 20130430121600, cucm, location,76,2 20130430121600,cucm1,location1,76,4 20130430122000,cucm,location,80,8 20130430122000,cucm1,location1,90,8 20130430140000,cucm1,location1,87,11 20130430140000, cucm,location,67,9
This is the required output
... (1 Reply)
Discussion started by: Lakshmikumari
1 Replies
10. Shell Programming and Scripting
In the awk I am trying to subtract the difference $3-$2 of each matching $4 before the first _ (underscore) and print that value in $13.
I think the awk will do that, but added comments. What I am not sure off is how to add a line or lines that will add sum each matching $13 value and put it in... (2 Replies)
Discussion started by: cmccabe
2 Replies
LEARN ABOUT OPENSOLARIS
diff3
diff3(1) User Commands diff3(1)
NAME
diff3 - 3-way differential file comparison
SYNOPSIS
diff3 [-exEX3] filename1 filename2 filename3
DESCRIPTION
diff3 compares three versions of a file. It publishes disagreeing ranges of text flagged with the following codes:
==== all three files differ
====1 filename1is different
====2 filename2is different
====3 filename3is different
The type of change suffered in converting a given range of a given file to some other is indicated in one of the following ways:
f : n1 a Text is to be appended after line number n1 in file f, where f = 1, 2, or 3.
f : n1 , n2 c Text is to be changed in the range line n1 to line n2. If n1 = n2, the range can be abbreviated to n1.
The original contents of the range follows immediately after a c indication. When the contents of two files are identical, the contents of
the lower-numbered file is suppressed.
The following command applies the resulting script to filename1.
(cat script; echo a'1,$pa') | ed - filename1
OPTIONS
The following options are supported:
-e Produce a script for the ed(1) editor that incorporates into filename1 all changes between filename2 and filename3 (that is, the
changes that normally would be flagged ==== and ====3).
Text lines that consist of a single dot (. defeat the -e option.
-E Produce a script that incorporates all changes between filename2 and filename3, but treat overlapping changes (that is, changes that
would be flagged with ==== in the normal listing) differently. The overlapping lines from both files are inserted by the edit
script, bracketed by <<<<<< and >>>>>> lines.
-x Produce a script to incorporate only changes flagged ====.
-X Produce a script that incorporates only changes flagged ====, but treat these changes in the manner of the -E option.
-3 Produce a script to incorporate only changes flagged ====3.
USAGE
See largefile(5) for the description of the behavior of diff3 when encountering files greater than or equal to 2 Gbyte ( 2^31 bytes).
FILES
/tmp/d3*
/usr/lib/diff3prog
EXIT STATUS
The following exit values are returned:
0 Successful completion.
1 An error occurred. A difference was found or there was a fatal error.
>1 A fatal error occurred.
Return values do not work the same as diff(1) or other vendor's versions of diff3.
ATTRIBUTES
See attributes(5) for descriptions of the following attributes:
+-----------------------------+-----------------------------+
| ATTRIBUTE TYPE | ATTRIBUTE VALUE |
+-----------------------------+-----------------------------+
|Availability |SUNWesc |
+-----------------------------+-----------------------------+
|CSI |Enabled |
+-----------------------------+-----------------------------+
SEE ALSO
diff(1), attributes(5), largefile(5)
NOTES
Files longer than 64 Kbytes do not work.
SunOS 5.11 7 Nov 2005 diff3(1)