Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: awk modification for lines
Top Forums Shell Programming and Scripting awk modification for lines Post 302780387 by SkySmart on Thursday 14th of March 2013 02:28:03 PM
Old 03-14-2013
Quote:
Originally Posted by bipinajith
If you want to run it in single line, then you have to use semi-colon ; to separate statements:
Code:
awk -F'[=,]' '{V[++n]=$4;R[n]=$0}END{for(i=1;i<=n;i++) print R[i],(V[i]-V[i+1])/V[i]*100}' OFS=, file

thank you so much!!!!

---------- Post updated at 02:28 PM ---------- Previous update was at 12:47 PM ----------

sorry to bring this up again.

Code:
jime=8,yime=1.23243,lime=[Mar-12-(UTC)]
jime=1,yime=1.23018,lime=[Mar-12-(UTC)]
jime=8,yime=1.15371,lime=[Mar-12-(UTC)]

what if i want to do the percentage difference on the numbers in the first column? and then tack it to the results?

like this:


Code:
jime=8,yime=1.23243,lime=[Mar-12-(UTC)],474,803
jime=1,yime=1.23018,lime=[Mar-12-(UTC)],893,1600
jime=8,yime=1.15371,lime=[Mar-12-(UTC)],200,400


i tried:

Code:
awk -F'[=,]' '{V[++n]=$2;R[n]=$0}END{for(i=1;i<=n;i++) print R[i],( V[i+1] - V[i] ) / (V[i+1]>0?-V[i+1]:V[i+1]?V[i+1]<0?V[i+1]:-V[i+1]) *100}' OFS=,

but i'm pretty sure i mangled it and its incorrect. the problem i'm having with the numbers is, take a look at this:

Code:
8
1
8

the above number was at 8, then it went down to 1, then it went back up to 8.

so the results should be:

Code:
8,-700
1,700
8

notice the negative sign.

when i run this:
Code:
awk -F'[=,]' '{V[++n]=$2;R[n]=$0}END{for(i=1;i<=n;i++) print R[i],( V[i+1] - V[i] ) / (V[i+1]>0?-V[i+1]:V[i+1]) *100}'

i get:

Code:
8,-700
1,87.5
8

 

10 More Discussions You Might Find Interesting

1. 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

2. 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

3. 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

4. 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

5. 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

6. 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

7. 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

8. 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

9. 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

10. 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
All times are GMT -4. The time now is 04:17 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy