Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

help with writing a awk/sed script

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting help with writing a awk/sed script
# 1  
Old 08-22-2012
help with writing a awk/sed script
Hi,

I thought I am getting pretty good with sed and awk, but now I dont have a way out of this question.

I have a table
Code:
0.5 16
1.3 14
0.25 15
0.85 16

I want to make a column 3 which contains values that are (corresponding $2 value/sum of all $2).

Please help me out here.
Thanks.
# 2  
Old 08-22-2012
try this..

Code:
 sum_all=$(awk ' {sum+=$2} END { print sum}' file2)
 
 awk -v SM=$sum_all '{ print $0, ($2 / SM ) }' file2

0.5 16 0.262295
1.3 14 0.229508
0.25 15 0.245902
0.85 16 0.262295

Last edited by pamu; 08-22-2012 at 08:26 AM..
# 3  
Old 08-22-2012
hi,

I wanted $3 as ($2/summation of column 2)

Thanks
# 4  
Old 08-22-2012
can you quote column three value with example
# 5  
Old 08-22-2012
Code:
awk '{s[NR]=$2;a[NR]=$0;t+=$2}END{while(a[++i]) print a[i],s[i]/t}' file

This User Gave Thanks to elixir_sinari For This Post:
jamie_123
# 6  
Old 08-22-2012
Perfect elixir. Thanks a lot.

The solution should look like this
Code:
0.5 16 0.262295
1.3 14 0.229508
0.25 15 0.245902
0.85 16 0.262295

# 7  
Old 08-22-2012
Code:
awk 'BEGIN{i=1;s=0}{a[i]=$0;s+=$2;i++}END{for(j=1;j<i;j++){split(a[j],b);print a[j],b[2]/s}}' infile

This User Gave Thanks to raj_saini20 For This Post:
jamie_123
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Getting output with sed without writing to a file

HI I am trying to grep 3 characters from hostname and append a character at the end. I tried as in the following: root@abag3:~# hostname | cut -c1-3 hyu Now I am trying to append "g" at the end of this output as in the following. root@abag3:~# hostname | cut -c1-3 | sed -s... (4 Replies)
Discussion started by: Priya Amaresh
4 Replies

2. UNIX for Dummies Questions & Answers

awk: issues for writing a script

%%%%% (7 Replies)
Discussion started by: lucasvs
7 Replies

3. UNIX for Dummies Questions & Answers

Writing awk script to read csv files and split them

Hi Here is my script that calls my awk script #!/bin/bash set -x dir="/var/local/dsx/csv" testfile="$testfile" while getopts " f: " option do case $option in f ) testfile="$OPTARG";; esac; done ./scriptFile --testfile=$testfile >> $dir/$testfile.csv It calls my awk... (1 Reply)
Discussion started by: ladyAnne
1 Replies

4. Shell Programming and Scripting

Help in writing a find/replace script using awk

Hi All, I need to write a script that will go through 600+ files and perform find and replace. I was going to use sed but there is a level of complexity that is doing my head in. To explain: I have 600+ files that have a line in them that reads (for example) FILE=DCLCLHST... (4 Replies)
Discussion started by: Kocko
4 Replies

5. Shell Programming and Scripting

Help needed in writing awk script for xml source

Hi, i am not able to get an approach for converting xml file to flat file using awk programming. Can anyone help me out. The input xml is like this: <outer> <field1>one</field1> <field2>two</field2> <field3>three<Error Code=777 Description=12345/></field3> <field4>four</field4> </outer>... (2 Replies)
Discussion started by: naren_0101bits
2 Replies

6. Shell Programming and Scripting

AWK/SED script help

Hi, was hoping someone may be able to help me with a script solution to move one line to another line from my log file: My log file currently looks like this: 01:21:12:383 Request 01:21:12:639 Response 01:21:12:386 Request 01:21:12:639 Response 01:21:12:389 Request 01:21:12:640 Response... (8 Replies)
Discussion started by: jimbobla
8 Replies

7. Shell Programming and Scripting

plz help in writing awk script

hi buddies pls help in this matter i have file like this input file -------------------------- (PARTITION PARTITION_1 VALUES LESS THAN (101, 16383 ) TABLESPACE PART_1 ,PARTITION PARTITION_2 VALUES LESS THAN (101, 32766 ) TABLESPACE PART_2 ,PARTITION PARTITION_3 VALUES LESS THAN (101,... (3 Replies)
Discussion started by: LAKSHMI NARAYAN
3 Replies

8. Shell Programming and Scripting

help in writing awk script, plz urgent

I have a file like this I have to I have input file this , I want to give the out put in the below input file (NARAYANA 1 ENDING AT (100, 16383) ,NARAYANA 2 ENDING AT (100, 32766) ,NARAYANA 3 ENDING AT (100, 49149) ,NARAYANA 4 ENDING AT (100, 65535) ,NARAYANA 5... (8 Replies)
Discussion started by: LAKSHMI NARAYAN
8 Replies

9. Shell Programming and Scripting

hi help in writing awk script(urgently)

hi to all i have file like this file.txt this is naryana expect hyderabad is a cool place now climate VISAKHSAPATNAM became very cool #vizag is my birth place #hyderabad is a cool place #now climate of hyd became very cool #vizag is my birth place #hyderabad is a cool place ... (7 Replies)
Discussion started by: LAKSHMI NARAYAN
7 Replies

10. Shell Programming and Scripting

Script for writing to files with sed

I have a problem with syntax methinks, when it comes to sed. This is my script for a user to type sed commands:- yes=y function writefunction { $tool $command $newfilename $filename } echo echo echo "1. Type the name of the tool you are using i.e sed." read tool echo... (3 Replies)
Discussion started by: Trufla
3 Replies
Login or Register to Ask a Question