Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

awk modification for lines

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting awk modification for lines
# 8  
Old 03-14-2013
As per the formula, the results are correct:
Code:
jime=8,yime=1.23243,lime=[Mar-12-(UTC)],lap=985434334,-700,#       Formula: (1 - 8) / 1 * 100
jime=1,yime=1.23018,lime=[Mar-12-(UTC)],lap=938354343,700,#        Formula: (8 - 1) / 1 * 100
jime=8,yime=1.15371,lime=[Mar-12-(UTC)],lap=482323232,62.5,#       Formula: (13 - 8) / 8 * 100
jime=13,yime=1.00371,lime=[Mar-12-(UTC)],lap=482323232,-85.7143,#  Formula: (7 - 13) / 7 * 100
jime=7,yime=1.31371,lime=[Mar-12-(UTC)],lap=482323232,-250,#       Formula: (2 - 7) / 2 * 100
jime=2,yime=1.09371,lime=[Mar-12-(UTC)],lap=482323232

If this formula is not correct, you have to change it as per your requirement.
# 9  
Old 03-14-2013
Quote:
Originally Posted by bipinajith
As per the formula, the results are correct:
Code:
jime=8,yime=1.23243,lime=[Mar-12-(UTC)],lap=985434334,-700,#       Formula: (1 - 8) / 1 * 100
jime=1,yime=1.23018,lime=[Mar-12-(UTC)],lap=938354343,700,#        Formula: (8 - 1) / 1 * 100
jime=8,yime=1.15371,lime=[Mar-12-(UTC)],lap=482323232,62.5,#       Formula: (13 - 8) / 8 * 100
jime=13,yime=1.00371,lime=[Mar-12-(UTC)],lap=482323232,-85.7143,#  Formula: (7 - 13) / 7 * 100
jime=7,yime=1.31371,lime=[Mar-12-(UTC)],lap=482323232,-250,#       Formula: (2 - 7) / 2 * 100
jime=2,yime=1.09371,lime=[Mar-12-(UTC)],lap=482323232

If this formula is not correct, you have to change it as per your requirement.
i apologize if i wasn't clear. this is what i meant:

Code:
jime=8,yime=1.23243,lime=[Mar-12-(UTC)],lap=985434334,-700,#       Formula: (8 - 1) / 8 * 100
jime=1,yime=1.23018,lime=[Mar-12-(UTC)],lap=938354343,700,#        Formula: (1 - 8) / 1 * 100
jime=8,yime=1.15371,lime=[Mar-12-(UTC)],lap=482323232,62.5,#       Formula: (8 - 13) / 8 * 100
jime=13,yime=1.00371,lime=[Mar-12-(UTC)],lap=482323232,-46.1538,#  Formula: (13 - 7) / 13 * 100
jime=7,yime=1.31371,lime=[Mar-12-(UTC)],lap=482323232,-71.4286,#       Formula: (7 - 2) / 7 * 100
jime=2,yime=1.09371,lime=[Mar-12-(UTC)],lap=482323232

formular should be:

Code:
(orignumber - newnumber) / orignumber * 100

the hard part is making the resulting number produce a negative or positive, depending on if the newnumber is greater than the orignumber.

sorry for the inconvenience
Last edited by SkySmart; 03-14-2013 at 06:11 PM..
# 10  
Old 03-14-2013
Code:
awk -F'[=,]' ' {
        V[++n] = $2
        R[n]  = $0
} END {
        for ( i = 1; i <= n; i++) {
                if(V[i+1] > 0)
                        print R[i], ((V[i] - V[i+1]) / V[i]) * 100
                else
                        print R[i]
        }
} ' OFS=, file

This User Gave Thanks to Yoda For This Post:
SkySmart
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Modification to awk command

i have a php file that has this: php.code #!/usr/bin/php <?php phpinfo(); hlight_file(__FILE__); ?> I want my awk code grab whatever is inbetween and including the "<?php" and "?>". Then, it should scan all the entries between these two points. And if the entries between these... (10 Replies)
Discussion started by: SkySmart
10 Replies

2. Shell Programming and Scripting

Merging multiple lines to columns with awk, while inserting commas for missing lines

Hello all, I have a large csv file where there are four types of rows I need to merge into one row per person, where there is a column for each possible code / type of row, even if that code/row isn't there for that person. In the csv, a person may be listed from one to four times... (9 Replies)
Discussion started by: RalphNY
9 Replies

3. Shell Programming and Scripting

awk script modification

can someone help me identify what i'm doing wrong here: awk -F'|' 'BEGIN{c=0} /./ && /./ { if ($3 < 2) { print ; c++ } END { print c":OK" } else if (($3 >= 2) && ($3 < 4)) { print ; c++ } END { print c":WARNING" } else if ($3 >= 4) { print ; c++ } END { print c":CRITICAL" } }'... (4 Replies)
Discussion started by: SkySmart
4 Replies

4. Shell Programming and Scripting

awk script modification - treat certain files differently

awk 'BEGIN{OFS=","} FNR == 1 {if (NR > 1) {print fn,fnr,nl} fn=FILENAME; fnr = 1; nl = 0} {fnr = FNR} /UNUSUAL/ && /\.gz/ ~ /FILENAME/ {nl++} <'{system ("gunzip -cd FILENAME")}' END ... (2 Replies)
Discussion started by: SkySmart
2 Replies

5. Shell Programming and Scripting

IP Address Modification through awk/sed

Hi, I have to modify the 2nd and 3rd octet of the IP address through awk/sed. For Example: Given IP is : 10.205.22.254, it should be modified as 10.105.100.254 through awk/sed. Kindly help me on this and let me know if you have any questions. Thanks in advances. (2 Replies)
Discussion started by: kumarbka
2 Replies

6. UNIX for Dummies Questions & Answers

awk output modification

Hello, I am using awk command to print some output, but there are some characters that I would like to remove from the output awk '{print $5$6}' the output I get is column5/:column6 I am looking forward to remove the : and to get the output column5/column6 Sorry if this question is... (4 Replies)
Discussion started by: Error404
4 Replies

7. Shell Programming and Scripting

awk script modification

I want the below script to omit every chunk of data that contains a specific hostname. here's the scenario. i have a configuration file that contains the configuration of several hosts. a sample of this configuration file is this: define host { address ... (12 Replies)
Discussion started by: SkySmart
12 Replies

8. Shell Programming and Scripting

Awk modification

I need help modifying the code below. DATAFILE is a log file. I have two strings i need to search for in the log file. The two strings are: 1. ERROR 2. com.rolander.promotions.client awk 'BEGIN { while((getline < "'${SFILE}'")>0) S FS="\n"; RS="\n" } (11 Replies)
Discussion started by: SkySmart
11 Replies

9. Shell Programming and Scripting

in line modification in a file using awk

Hi, I have a conf.file with the following values: ef=78 b=40 ca=40 c=45/dev2 when I modify one of the line with the below awk script,it's modifying BUT it's placing the modified line in the last line : input:- Configure b 45/dev4 output:- ef=78 ca=40 ... (2 Replies)
Discussion started by: axes
2 Replies

10. Shell Programming and Scripting

Operations on a file with Deletion , Modification and Insertion of lines

Hi All , Given a file , I need to delete , modify and insert lines matching certain patterns in that file using shell scripting. e.g. If a file FILE1 has following content : CUST.ABC.DEF = CUST.ABC.DEF * CUST.ABC.DEF PRINTF(CUST.ABC.DEF) CUST.ABC.DEF = mid(CUST.ABC.DEF,10.34)... (5 Replies)
Discussion started by: swapnil.nawale
5 Replies
Login or Register to Ask a Question