How can I add 4 lines together and then read the next 4 lines?


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting How can I add 4 lines together and then read the next 4 lines?
# 22  
Old 11-25-2008
Quote:
Originally Posted by mr_andrew
That worked fine.. It extracted all ao total..
Only Total, or Total and exe?

It should return the lines 081125_08:38 14315 2.39 SOM.exe ... too.
# 23  
Old 11-25-2008
awk '/Total|\.exe/' nisse_081121_11.log

081125_09:38 14315 2.32 SOM.exe
AO Total = 9002
AO Total = 2543
AO Total = 434
AO Total = 45241

I got both..
# 24  
Old 11-25-2008
Try changing the code like this:


Code:
awk -F= 'END {
  if (t) 
    print e, "Total:", t
}
/\.exe/ { 
  if (t) 
    print e, "Total:", t
  t = 0
  e = $0
  }
/Total/ { t += $NF }
' nisse_081121_11.log


Last edited by radoulov; 11-26-2008 at 04:17 AM..
# 25  
Old 11-26-2008
Thanks for your effort now it works.

# awk 'END {
> if (t)
> print e, "Total:", t
> }

if (t)
> /\.exe/ {
> if (t)
> print e, "Total:", t
> t = 0
> e = $0 }
/Total/ { t += $NF }
' nisse_081121_11.log
> }
> /Total/ { t += $NF }
> ' nisse_081121_11.log
081125_08:38 14315 2.39 798928 198257 SOM.exe Total: 56098
081125_09:38 14315 2.32 798928 198257 SOM.exe Total: 57220
#

If I want to search for another word, would it just do to change Total?

/Total/ { t += $NF }

And if it is not that clean as it is now with the numbers. If it was text after it. I.e

Total houses = 32245 houses

Would it still work?
# 26  
Old 11-26-2008
It should, try it.
If it looks like a number, for AWK it is a number.
# 27  
Old 11-26-2008
It did not work.

I added
AO Total = 3423 Alarm Objects

Does awk interpret it as the same as without "Alarm Objects"?
# 28  
Old 11-26-2008
I cannot reproduce it, could you post sample data, commands and output:

Code:
$ print AO Total = 3423 Alarm Objects | awk -F= '{print $NF+1}'
3424

Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Read few last lines of a file

Hi, I have a txt file in below format - START 1 2 3 4 END START 5 6 7 8 END START 9 10 END (8 Replies)
Discussion started by: bhupinder08
8 Replies

2. Shell Programming and Scripting

Extract some lines from one file and add those lines to current file

hi, i have two files. file1.sh echo "unix" echo "linux" file2.sh echo "unix linux forums" now the output i need is $./file2.sh unix linux forums (3 Replies)
Discussion started by: snreddy_gopu
3 Replies

3. Shell Programming and Scripting

search and replace, when found, delete multiple lines, add new set of lines?

hey guys, I tried searching but most 'search and replace' questions are related to one liners. Say I have a file to be replaced that has the following: $ cat testing.txt TESTING AAA BBB CCC DDD EEE FFF GGG HHH ENDTESTING This is the input file: (3 Replies)
Discussion started by: DeuceLee
3 Replies

4. UNIX for Dummies Questions & Answers

When reading a csv file, counter to read 20 lines and wait for minute then read next 20 till end

Hello All, i am a newbie and need some help when reading a csv file in a bourne shell script. I want to read 10 lines, then wait for a minute and then do a reading of another 10 lines and so on in the same way. I want to do this till the end of file. Any inputs are appreciated ... (3 Replies)
Discussion started by: victor.s
3 Replies

5. Shell Programming and Scripting

How to read different lines into column

Dear experts, Need your great help ! The input file is as follows: Name: test01 Name UID: C7:9D:79:52:2A:3F:DF:11:A8:64:00:60:16:36:04:02 Shareable: YES HBA/SP Pairs: HBA UID SP Name SPPort ------- ... (9 Replies)
Discussion started by: tojzz
9 Replies

6. Shell Programming and Scripting

Help!! Need script to read files and add values by lines...

Hi All, I really need your help. I am a begginner in shell script and I believe this is a very simple issue. I have in my directory, n-files, like 1.dhm, 2.dhm, 3.dhm. These files have 1 column with 1 value per line, like: 1.dhm ------ 10 20 30 40 50 2.dhm ------ 30 50 20 (3 Replies)
Discussion started by: dhuertas
3 Replies

7. UNIX for Dummies Questions & Answers

How to count lines - ignoring blank lines and commented lines

What is the command to count lines in a files, but ignore blank lines and commented lines? I have a file with 4 sections in it, and I want each section to be counted, not including the blank lines and comments... and then totalled at the end. Here is an example of what I would like my... (6 Replies)
Discussion started by: kthatch
6 Replies

8. Shell Programming and Scripting

read some lines from file!!!

any idea please!!! I want to pick up all lines of "state" and "desc" from x files: ... # state blah blah blah blah ... .. # desc blah blah blah .... Thx Andy (7 Replies)
Discussion started by: andy2000
7 Replies

9. UNIX for Dummies Questions & Answers

Read lines from file

i have a problem on my bourne shell script. I want to read line by line and then stop when the line does not have letters or is an empty string. But i encounter an error at "while ". The error nessage is "test.sh: test: unknown operator line". Can anyone help me on this thanks :) (2 Replies)
Discussion started by: sagolo
2 Replies

10. UNIX for Dummies Questions & Answers

how to read lines one by one from a file

I have one file in which some commands have written line line i have to read lines from this file(file name passed as avariable) and then i have to execute these commands.. how can i do it? (5 Replies)
Discussion started by: bihani4u
5 Replies
Login or Register to Ask a Question