I have 3 file, each of has got 80000 records.
file1.txt
-----------------------
ABC001;active;modify;accept;
ABC002;notactive;modify;accept;
ABC003;notactive;no-modify;accept;
ABC004;active;modify;accept;
ABC005;active;no-modify;accept;
file2.txt
---------------------------... (8 Replies)
Hi all,
Ive searched the forum but with no luck...
I have a file:
ID Name Val
1 bob 45
2 joe 89
3 sue 11
4 steve 89
...
etc
I want to find a way to print... (6 Replies)
Hello all,
this should really be easy for you... I need AWK to print column maxima for each column of such input:
Input:
1 2 3 1
2 1 1 3
2 1 1 2
Output should be:
2 2 3 3
This does the sum, but i need max instead:
{ for(i=1; i<=NF; i++)
sum +=$i }
END {for(i=1; i in sum;... (3 Replies)
I have 100 data files labelled 250.1.txt through 250.100.txt. The second column of the data files partially match (there is about %90 overlap). Each data file has 4 columns.
I want the merge all these text files by the matching values in the second column. In the output, the first column should... (1 Reply)
Hi guys,
I already search on the forum but i can't solve this on my own.
I have a lot of files like this:
And i need to print the line with the maximum value in last column but if the value is the same (2 in this exemple for the 3 last lines) i need get the line with the minimum value in... (4 Replies)
Hello,
I have some problem in the modified shell script. I would like to merge the same word in column 1 in one line.
Example :
A1 B1 2
A2 B1 4
A3 B1 7
A1 B2 1
A2 B2 10
A3 B2 8
Expected output :
A1 B1 B2 2 1
A2 B1 B2 4 10
A3 ... (6 Replies)
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)
I need to find the max value of all columns except the 1st column and print the answer along with the 1st column.
Input
123xyz 0 0 1 2 0 0 0 0 0 0 0
234xyz 0 0 0 0 0 0 0 0 0 0 0
345xyz 0 0 1 0 0 0 ... (8 Replies)
Hello,
I have this table:
chr1_16857_17742 - chr1 17369 17436 "ENST00000619216.1"; "MIR6859-1"; - 67
chr1_16857_17742 - chr1 14404 29570 "ENST00000488147.1"; "WASH7P"; - 885
chr1_16857_18061 - chr1 ... (5 Replies)
Discussion started by: coppuca
5 Replies
LEARN ABOUT HPUX
sdiff
sdiff(1) General Commands Manual sdiff(1)NAME
sdiff - side-by-side difference program
SYNOPSIS
[options ...] file1 file2
DESCRIPTION
uses the output of diff(1) with the option, which ignores trailing blanks (spaces and tabs) and treats other strings of blanks as equal, to
produce a side-by-side listing of two files, indicating those lines that are different. Each line of the two files is printed with a blank
gutter between them if the lines are identical, a in the gutter if the line only exists in file1, a in the gutter if the line only exists
in file2, and a for lines that are different.
For example:
abc | xyz
abc abc
bca <
cba <
dcb dcb
> cde
Options
recognizes the following options:
Use the next argument,
n, as the width of the output line. The maximum value of n is 2048 (LINE_MAX). The default line length is 130 charac-
ters.
Only print on the left side when lines are identical.
Do not print identical lines.
Use the next argument,
output, as the name of a third file that is created as a user-controlled merging of file1 and file2. Identical lines of
file1 and file2 are copied to output. Sets of differences, as produced by diff(1), are printed; where a set of differ-
ences share a common gutter character. After printing each set of differences, prompts the user with a and waits for
one of the following user-typed commands:
append the left column to the output file
append the right column to the output file
turn on silent mode; do not print identical lines
turn off silent mode
call the editor with the left column
call the editor with the right column
call the editor with the concatenation of left and right
call the editor with a zero length file
exit from the program
On exit from the editor, the resulting file is concatenated on the end of the output file.
EXAMPLES
Print a side-by-side diff of two versions of a file on a printer capable of printing 132 columns:
Retrieve the most recently checked in version of a file from RCS and compare it with the version currently checked out:
SEE ALSO diff(1), ed(1).
sdiff(1)