Sponsored Content
Top Forums UNIX for Dummies Questions & Answers loop? print max column in each line for 800 files and merge Post 302544035 by Shell_Life on Tuesday 2nd of August 2011 06:04:09 PM
Old 08-02-2011
Code:
#!/usr/bin/ksh
rm -f xyz.File_*.xyz
ls -1 File_* | while read mFName; do
  mOtherFN='xyz.'${mFName}'.xyz'
  while read mLine; do
    mMax=$(echo ${mLine} | tr ' ' '\n' | sort -r | head -1)
    echo ${mMax} >> ${mOtherFN}
  done < ${mFName}
done
paste xyz.File_*.xyz
rm -f xyz.File_*.xyz

This User Gave Thanks to Shell_Life For This Post:
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

compare the column from 3 files and merge that line

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)
Discussion started by: ganesh_mak
8 Replies

2. Shell Programming and Scripting

Help: Find line where column has max vlaue

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)
Discussion started by: muay_tb
6 Replies

3. Shell Programming and Scripting

loop in awk - column max for each column

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)
Discussion started by: irrevocabile
3 Replies

4. UNIX for Dummies Questions & Answers

Writing a loop to merge multiple files by common column

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)
Discussion started by: evelibertine
1 Replies

5. UNIX for Dummies Questions & Answers

[Solved] Print a line using a max and a min values of different columns

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)
Discussion started by: MetaBolic0
4 Replies

6. Shell Programming and Scripting

merge same pattern of same column in one line

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)
Discussion started by: awil
6 Replies

7. Shell Programming and Scripting

Print min and max value from two column

Dear All, I have data like this, input: 1254 10125 1254 10126 1254 10127 1254 10128 1254 10129 1255 10130 1255 10131 1255 10132 1255 10133 1256 10134 1256 10135 1256 10137... (3 Replies)
Discussion started by: aksin
3 Replies

8. Shell Programming and Scripting

Merge two files line by line and column by column

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

9. Shell Programming and Scripting

Find Max value of line and print

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)
Discussion started by: ncwxpanther
8 Replies

10. UNIX for Beginners Questions & Answers

Print a row with the max number in a column

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
kvar(8) 						      System Manager's Manual							   kvar(8)

Name
       kvar - modify RISC kernel variables in memory or on disk

Syntax
       /usr/etc/kvar -r(b|w|l) [options] vmunix
       /usr/etc/kvar -w(b|w|l) [options] vmunix

Description
       The  command  allows you to read or write RISC kernel variables, either in the on-disk image of or the active in-memory image.  The -r form
       of the command does variable reads; the -w form does variable writes.  The variable length qualifiers are:  b  (1  byte),  w  (word,  or  2
       bytes), and l (longword, or 4 bytes).

       Variable contents are displayed in hexadecimal format.

Options
       -a address  Specifies  the  address  of	the  kernel  variable.	Either the -a or -s option must be specified.  The address is specified as
		   either a positive decimal or hexadecimal constant.

       -k	   Instructs to use the in-memory image of The default is to use the on-disk copy.

       -l	   Searches for a local symbol. The default is a global symbol search.

       -o offset   Adds an offset to the address (or address of the symbol name).  The offset value is specified as either a positive  decimal	or
		   hexadecimal constant.

       -s name	   Specifies the name of the kernel variable.

       -v value    Specifies  the  new value to be assigned by the -w form of The -v option is ignored if the -r form of is being used.  The value
		   is specified as either a positive decimal or hexadecimal constant.

Restrictions
       You must have appropriate file access permissions for (and for with the -k option).

       The command is available only on RISC systems.  For VAX systems, use to modify kernel variables.

Examples
       This example reads the variable `udpcksum' from the running kernel image:

	    % kvar -k -rl -s udpcksum /vmunix

       This example sets the `xyz' variable to zero in the running kernel image:

	      % kvar -k -wl -s xyz -v 0 /vmunix

       This example sets the variable `xyz' to -1 in the on-disk image of making this value persistent across reboots:

	      % kvar -wl -s xyz -v 0xffffffff /vmunix

       This example sets to zero 1 byte at offset 2 from address 0x80161a98 in the running kernel image:

	      % kvar -k -wb -o 2 -a 0x80161a98 /vmunix

Files
See Also
       adb(1), dbx(1)

								       RISC								   kvar(8)
All times are GMT -4. The time now is 10:34 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy