Sponsored Content
Top Forums Shell Programming and Scripting Locating the largest number and performing division Post 302851681 by Kanja on Monday 9th of September 2013 01:04:35 PM
Old 09-09-2013
Locating the largest number and performing division

I have a tab delimited file with the following format

Code:
1 r 109 45 3 5 6 7
2 f  300 249 5 8 10
3 g 120 4 5 110 0
4 t 400 300 250 0 0
.....
.....
100,000 lines

I would like to get the largest number in columns 4, 5, 6, 7, 8 and divide that largest number with the number in column 3.

Desired output
Code:
1 r 109 45 3 5 6 7 0.41
2 f  300 249 5 8 10 0.83
3 g 120 4 5 110 0 0.9166
4 t 400 300 250 0 0 0.75

I tried excel today this but since it has over 100,000 lines, it is difficult to do it. Please let me know the best way to do it awk or see.
 

7 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

search the largest number and duplicates string

Hi, My input file contain list of username, and it may have name with number as a suffix (if duplicated). Ex: mary john2 mike john3 john5 mary10 alexa So i want to check with a specific username (without suffix number) how many duplicated name, and what is the... (13 Replies)
Discussion started by: fongthai
13 Replies

2. Shell Programming and Scripting

checking the smallest and largest number

Hi All, My script is reading a log file line by line log file is like ; 19:40:22 :INFO Total time taken to Service External Request---115ms 19:40:25 DEBUG : Batch processed libdaemon.x86_64 0-0.10-5.el5 - u 19:40:22 INFO Total time taken to Service External Request---20ms 19:40:24... (4 Replies)
Discussion started by: subin_bala
4 Replies

3. UNIX for Dummies Questions & Answers

How to print largest and smallest number.

Hey. This is pretty easy stuff but I'm learning the basics of Unix at the moment so keep that in mind. I have to: 1) Write a C-shell script to monitor user activity on the server for 13 minutes. 2) Then print the smallest and largest number of users during these 13 minutes. I have this: 1)... (2 Replies)
Discussion started by: amp10388
2 Replies

4. HP-UX

Division returning a negative number

Hi All, Just faced an interesting thing in HP-UX. I was dividing 2955334616 / 2 by using echo `expr 2955334616 / 2` , and this ofcourse which expects 1477667308 to be returned. But I am getting -669816340 and I am :wall: how exactly this is possible. It is not one of the compliments (Ones or... (4 Replies)
Discussion started by: mail2sanand
4 Replies

5. Shell Programming and Scripting

awk second largest, third largest value

I have two text files like this: file1.txt: 133 10 133 22 133 13 133 56 133 78 133 98 file2.txt: 158 38 158 67 158 94 158 17 158 23 I'm basically trying to have awk check the second largest value of the second column of each text file, and cat it to its own text file. There... (13 Replies)
Discussion started by: theawknewbie
13 Replies

6. Shell Programming and Scripting

Taking largest (negative) number from column of coordinates and adding positive form to every other

Hello all, I'm new to the forums and hope to be able to contribute something useful in the future; however I must admit that what has prompted me to join is the fact that currently I need help with something that has me at the end of my tether. I have a PDB (Protein Data Bank) file which I... (13 Replies)
Discussion started by: crunchgargoyle
13 Replies

7. Shell Programming and Scripting

Largest number in array. Help!

I need to calculate the biggest number in array size n. Example: Users enter: 1 7 4 9 The biggest number is : 9 Simple but I'm really new on this on Shell/Bash! Anything will be helpful! Thanks! #!/bin/bash printf "\tEnter a list of numbers, with spaces: " read -a ARRAY BIG=$1... (5 Replies)
Discussion started by: Sundown
5 Replies
ogamesim(6)							   Games Manual 						       ogamesim(6)

NAME
Console Ogame Simulator SYNOPSYS
ogamesim [ -i <task.txt> ] [ -o <result.txt> ] DESCRIPTION
Tasks for simulation are consist of text files. Example of task concluding all possible units is adduced bellow. OPTIONS
-i <input file>: task file (STDIN unless defined); -o <output file>: result file (STDOUT unless defined); -s <iterations count>: 1 <= value <= N (no limits); -t <max simulation time>: (seconds) 0 <= value <= N, 0=no limits; -f <forks count>: 0 <= value <= 100. RETURN VALUES
0: if success EXAMPLES
Task concluding all possible units: attacker attack = 9 shield = 10 armory = 11 Small Cargo = 10 Large Cargo = 10 Light Fighter = 20 Heavy Fighter = 30 Cruiser = 40 Battleship = 50 Colony Ship = 60 Recycler = 70 Espionage Probe = 80 Bomber = 900 Destroyer = 110 Deathstar = 120 defender attack = 11 shield = 12 armory = 13 Rocket Launcher = 100 Light Laser = 200 Heavy Laser = 300 Gauss Cannon = 400 Ion Cannon = 500 Plasma Turret = 600 Small Shield Dome = 1 Large Shield Dome = 1 Solar Satellite = 100 metal = 123456 crystal = 56789 deut = 987654 ogamesim Dec 4, 2006 ogamesim(6)
All times are GMT -4. The time now is 05:02 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy