Combine identical lines and average the one variable field Post: 302905373

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

replace 2 identical strings on different lines

I am looking to replace two or more strings on different lines using sed, but not with the same variable. IE # cat xxx.file <abc> abc def ghi abc def ghi abc def ghi currently I can only change each line with the same pattern: # sed -e '/<abc>/!s/abc$.*$/jkl mno/' xxx.file abc jkl mno...

2. Shell Programming and Scripting

Ignore identical lines

Hello Experts, I have two files called "old" and "new". My old file contains 10 lines and my new file contains 10 + "n" lines. The first field in both these files contain ID. I sort these two files on ID. I am interested in only the lines that are in the new file and not in old. I tried...

3. Shell Programming and Scripting

print running field average for a set of lines

Hi everyone, I have a program that generates logs that contains sections like this: IMAGE INPUT 81 0 0.995 2449470 0 1726 368 1 0.0635 0.3291 82 0 1.001 2448013 0 1666 365 1 0.0649 0.3235 83 0 1.009 2444822 0 1697 371 1 ...

4. UNIX for Dummies Questions & Answers

more than 10 identical lines

I have a file that looks like this 10 user1s, 5 user2s and 10 users3. 10.10.1.1 user1 10.10.1.1 user1 10.10.1.1 user1 10.10.1.1 user1 10.10.1.1 user1 10.10.1.1 user1 10.10.1.1 user1 10.10.1.1 user1 10.10.1.1 user1 10.10.1.1 user1 10.10.1.2 user2 10.10.1.2 user2 10.10.1.2 user2...

5. Shell Programming and Scripting

Combine multiple lines in file based on specific field

Hi, I have an issue to combine multiple lines of a file. I have records as below. Fields are delimited by TAB. Each lines are ending with a new line char (\n) Input -------- ABC 123456 abcde 987 890456 7890 xyz ght gtuv ABC 5tyin 1234 789 ghty kuio ABC ghty jind 1234 678 ght ...

6. Shell Programming and Scripting

sed print all lines between second and third identical lines

I am trying to extract a table of data (mysql query output) from a log file. I need to print everything below the header and not past the end of the table. I have spent many hours searching with little progress. I am matching the regexp +-\{99\} with no problem. I just can't figure out how to print...

7. Shell Programming and Scripting

awk to combine by field and average by another

In the below awk I am trying to combine all matching $4 into a single $5 (up to the -), and count the lines in $6 and average all values in $7. The awk is close but it seems to only be using the last line in the file and skipping all others. The posted input is a sample of the file that is over...

8. UNIX for Dummies Questions & Answers

Combine Similar Output from the 2nd field w.r.t 1st Field

Hi, For example: I have: HostA,XYZ HostB,XYZ HostC,ABC I would like the output to be: HostA,HostB: XYZ HostC:ABC How can I achieve this? So far what I though of is:

9. UNIX for Beginners Questions & Answers

How to delete identical lines while leaving one undeleted?

Hi, I have a file as follows. file1 Hello Hi His Hi Hi Hungry hi so I want to delete identical lines while leaving one of them undeleted. So desired output will be Hello Hi

10. UNIX for Beginners Questions & Answers

awk - If field value of consecutive records are the identical print portion of lines

I have some data that looks like this: PXD= ZW< 1,6 QR> QRJ== 1,2(5) QR> QRJ== 4,1(2) QR> QRJ== 4,2 QRB= QRB 4,2 QWM QWM 6,2 R<C ZW< 11,2 R<H= R<J= 6,1 R>H XZJ= 1,2(2) R>H XZJ= 2,6(2) R>H XZJ= 4,1(2) R>H XZJ= 6,2 RDP RDP 1,2 What I would like to do is if fields $1 and $2 are...

LEARN ABOUT ULTRIX

pnmdepth

pnmdepth(1)                                                   General Commands Manual                                                  pnmdepth(1)

NAME

       pnmdepth - change the maxval in a portable anymap

SYNOPSIS

       pnmdepth newmaxval [pnmfile]

DESCRIPTION

       Reads a portable anymap as input.  Scales all the pixel values, and writes out the image with the new maxval.  Scaling the colors down to a
       smaller maxval will result in some loss of information.

       Be careful of off-by-one errors when choosing the new maxval.  For instance, if you want the color values to be five bits wide, use a  max-
       val of 31, not 32.

       One  important  use  of pnmdepth is to convert a new format 2-byte-per-sample PNM file to the older 1-byte-per-sample format.  Before April
       2000, essentially all raw (binary) format PNM files had a maxval less than 256 and one byte per sample, and many programs may rely on that.
       If  you  specify  a  newmaxval  less than 256, the resulting file should be readable by any program that worked with PNM files before April
       2000.

SEE ALSO

       pnm(5), ppmquant(1), ppmdither(1)

AUTHOR

       Copyright (C) 1989, 1991 by Jef Poskanzer.

                                                                   08 April 2000                                                       pnmdepth(1)

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

replace 2 identical strings on different lines

Discussion started by: prkfriryce

2. Shell Programming and Scripting

Ignore identical lines

Discussion started by: forumthreads

3. Shell Programming and Scripting

print running field average for a set of lines

Discussion started by: euval

4. UNIX for Dummies Questions & Answers

more than 10 identical lines

Discussion started by: lawsongeek