Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Formatting Help needed(Sed)

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Formatting Help needed(Sed)
# 1  
Old 06-22-2010
Formatting Help needed(Sed)
I have a file called abc.txt which has following contents.

Code:
10.180.8.231=31608
10.180.8.232=29011
10.180.8.233=31606
10.180.8.234=40501
10.180.8.235=32591
10.180.8.236=31605
10.180.8.237=30561
10.180.8.238=14231

How would i find a ip address having maximum number of ram available.
Here it is 10.180.8.234 which has 40501 mb ram

I used to run the following command to get the ip with maximum ram.
Code:
sort -n  -t '=' +1 abc.txt | sed -n  '$p' | awk -F "=" '{print $1}'

But since i moved to new server which has older version of sort it gives me an error saying file abc.txt doesnt exist.
Please suggest how would i modify the command so that it should work fine on new server.
Last edited by Franklin52; 06-22-2010 at 03:44 AM.. Reason: Please use code tags!
# 2  
Old 06-22-2010
Try,

Code:
$ awk -F'=' '$2 > a { a=$2;ip=$1 } END { print ip }'  inputfile

This User Gave Thanks to agn For This Post:
pinga123
# 3  
Old 06-22-2010
Code:
bash-3.2$ cat a.sample |sed s/'='/' '/g |sort -nrk2
10.180.8.234 40501
10.180.8.235 32591
10.180.8.231 31608
10.180.8.233 31606
10.180.8.236 31605
10.180.8.237 30561
10.180.8.232 29011
10.180.8.238 14231

Last edited by Franklin52; 06-22-2010 at 03:45 AM.. Reason: Please use code tags, thank you!
This User Gave Thanks to phoenix_nebula For This Post:
pinga123
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Help needed in formatting the output

Hi All, Need your help in resolving the below issue. I've a file called "data.txt" with the below lines: TT: <tell://me/sreenivas> <tell://me/100> <tell://me/500> TT: <tell://me/sudheer> <tell://me/300> TT: <tell://me/sreenivas> <tell://me/200> TT:... (6 Replies)
Discussion started by: raosr020
6 Replies

2. Shell Programming and Scripting

Help needed in formatting the Output file

Hi All, Need your help in resolving the below issue. I've a file called "data.txt" with the below lines: TT: <tell://me/sreenivas> <tell://me/100> TT: <tell://me/sudheer> <tell://me/300> TT: <tell://me/sreenivas> <tell://me/200> TT: <tell://me/sudheer> <tell://me/400> ... (3 Replies)
Discussion started by: raosr020
3 Replies

3. Shell Programming and Scripting

Help needed in formatting script files

Hi, Can anyone tell me how i can convert all tab spaces inside a script to 4 spaces through another script. Also i need to find if all the quotes are matching and ended properly. Any idea whould be of great help. Many thanks! (3 Replies)
Discussion started by: justchill
3 Replies

4. Shell Programming and Scripting

Formatting help needed awk or sed maybe

I am executing the following command: sort file1.txt | uniq -c | sort -n > file2.txt The problem is that in file 2, I get leading spaces, Like so: 1 N/A|A8MW11 8 N/A|ufwo1 9 N/A|a8mw11 10 900003|smoketest297688 10 N/A|a9dg4 10 danny|danni 12... (5 Replies)
Discussion started by: ddurden7
5 Replies

5. UNIX for Dummies Questions & Answers

Formatting Help needed

How would i write a script which will add a following content to a file. File Before running script. acpi = 1 apic = 1 builder = 'hvm' device_model = '/usr/lib/xen/bin/qemu-dm' disk = File After running the script. acpi = 1 apic = 1 builder = 'hvm' device_model =... (5 Replies)
Discussion started by: pinga123
5 Replies

6. Shell Programming and Scripting

Little formatting help needed.

I have a following string. "machine=IFLMUD5HP0581&group1=Stop" I have created 2 variables namely machine and action. machine should contain IFLMUD5HP0581 action should contain Stop How do i write a script for the same. (7 Replies)
Discussion started by: pinga123
7 Replies

7. Shell Programming and Scripting

Output formatting help needed.

Hi guys , I have a file which contains following string.(filename tempdisplay) (location 0.0.0.0:5900) i needed to write a script which will extract the string that comes after 0.0.0.0 i.e the string :5900. I have used following method to extract the string :5900 .Is it a preferred way of... (4 Replies)
Discussion started by: pinga123
4 Replies

8. Shell Programming and Scripting

sed formatting query

had asked this earlier , but now with some small modification. i wish to remove "#" characters and replace them with a single # character. how to do that? . like # should be appended in all lines ex if the file is like ####aasd ##pqr #qwert poppy output shud be #aasd #pqr #qwert... (2 Replies)
Discussion started by: gopsman
2 Replies

9. Shell Programming and Scripting

sed formatting query2

i wish to remove "#" characters and replace them with a single # character. how to do that? ex if the file is like ####aasd ##pqr ###pqr #qwert output shud be #aasd #pqr #pqr #qwert plz hlp (4 Replies)
Discussion started by: gopsman
4 Replies

10. Shell Programming and Scripting

sed formatting query

hi i have to modify a number accross a file for example in the following file name - abc age 20 name - def age 25 name - pqr age 54 name - xyz age 32 i want the number against all age to be say 50. like this name - abc age 50 name - def (2 Replies)
Discussion started by: gopsman
2 Replies
Login or Register to Ask a Question