Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Count per line in txt file

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Count per line in txt file
# 1  
Old 03-20-2012
Count per line in txt file
In a txt file called, eso.txt, I have:
PHP Code:
......
  3  where process_status_flag = 70 and LISTENER_ID in (930.00, 931.00, 932.00, 933.00, 934.00)
  4  group by LISTENER_ID
  5  order by LISTENER_ID;

  LISTENER      COUNT                                                           
---------- ----------                                                           
       930       5145                                                           
       931       5344                                                           
       932       5387                                                           
       933       5517                                                           
       934       4942                                                           

SQL> 
SQL> spool off 
I need to grep the below if any of LISTENER has more than 5,500 on COUNT and e-mail out to me.

PHP Code:
  LISTENER      COUNT                                                           
---------- ----------                                                           
       930       5145                                                           
       931       5344                                                           
       932       5387                                                           
       933       5517                                                           
       934       4942 
So, in this case, LISTENER 933 has more than 5,500 COUNT, I need to e-mail it out the entire of this.

PHP Code:
  LISTENER      COUNT                                                           
---------- ----------                                                           
       930       5145                                                           
       931       5344                                                           
       932       5387                                                           
       933       5517                                                           
       934       4942 
Please advise. Smilie
# 2  
Old 03-20-2012
Try:
Code:
awk 's{s=s RS $0} $2+0>5000{p=1} /^ *LISTENER /{s=$0} !NF && s && p{print s;exit}END{if(!p)exit 1}' infile

or
Code:
awk '/^ *LISTENER /{for(i=6; i<=NF; i+=2) if($i>5000)p=1;if(p)print;exit}END{if(!p)exit 1}' RS= infile

Last edited by Scrutinizer; 03-20-2012 at 12:36 PM..
This User Gave Thanks to Scrutinizer For This Post:
Daniel Gate
# 3  
Old 03-21-2012
Thank you so much! It works great!
# 4  
Old 03-22-2012
Try this..
Code:
 
awk '/LISTENER /,/SQL/{a=a"\n"$0;b[i]=$2;i++}END{gsub("SQL>","",a);for(i in b){if(b[i]>5500 && b[i]!~/[C\-]/){print b[i];print a;exit}}}'
  LISTENER      COUNT                                                            
---------- ----------                                                            
       930       5145                                                            
       931       5344                                                            
       932       5387                                                            
       933       5517                                                            
       934       4942

This User Gave Thanks to itkamaraj For This Post:
Daniel Gate
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Switch line in txt file

Hi I have problem with replace line in txt file , I have this string: 144185 DISK Piece qqr8ot6l_1_1 -- 144186 DISK Piece ukr8pf2e_1_1 -- 144187 DISK Piece ter8p9gc_1_1 -- 144188 DISK Piece 4er8qb84_1_1 and (8 Replies)
Discussion started by: primo102
8 Replies

2. UNIX for Dummies Questions & Answers

Split Every Line In Txt Into Separate Txt File, Named Same As The Line

Hi All Is there a way to export every line into new txt file where by the title of each txt output are same as the line ? I have this txt files containing names: Kandra Vanhooser Rhona Menefee Reynaldo Hutt Houston Rafferty Charmaine Lord Albertine Poucher Juana Maes Mitch Lobel... (2 Replies)
Discussion started by: Nexeu
2 Replies

3. Shell Programming and Scripting

Need to append the date | abcddate.txt to the first line of my txt file

I want to add/append the info in the following format to my.txt file. 20130702|abcd20130702.txt FN|SN|DOB I tried the below script but it throws me some exceptions. <#!/bin/sh dt = date '+%y%m%d'members; echo $dt+|+members+$dt; /usr/bin/awk -f BEGIN { FS="|"; OFS="|"; } { print... (6 Replies)
Discussion started by: harik1982
6 Replies

4. Shell Programming and Scripting

create txt file form data file and add some line on it

Hi Guys, I have file A.txt File A Data AK1521 AK2536 AK3164 I want create text file of all data above and write some data on each file. want Output on below folder /home/kka/out AK1521.txt Hi Welocme (3 Replies)
Discussion started by: asavaliya
3 Replies

5. Shell Programming and Scripting

Changing Line in Txt File

So I have a python program that I run, which runs accordingly to options I have listed in a text file (ie user_prefs). Now there are many options listed in this user_prefs.txt, but the one of most interest to me is that of the file path of the time series. I have over a hundred of these time... (8 Replies)
Discussion started by: Jimmyd24
8 Replies

6. Shell Programming and Scripting

count of null in pipe delimited txt file

Hi, I have a pipe delimited txt file which contains 17 fields per line/row. 16th field contains email id. I want to count the number of lines/rows that contains null in the 16th field. Plz find attached example data file. I'm looking for a command line/script which achieves this. ... (5 Replies)
Discussion started by: Sriranga
5 Replies

7. Shell Programming and Scripting

write filename as first line in a txt file

Could anyone very kindly help me a simple way to perform the - perhaps - very trivial task of writing the name of a file as first line of that file which is in txt format? And would be possible to do this recursively for some thousands files in the XY directory? And, again, add to the simple... (3 Replies)
Discussion started by: mjomba
3 Replies

8. Programming

Reading a particular line from a .txt file

Hi, I have a .txt file which contains the x, y and z co-ordinates of particles which I am trying to cast for a particular compound. The no. of particles present is of the order of 2 billion and hence the size of the text file is of the order of a few Gigabytes. The particles have been casted layer... (5 Replies)
Discussion started by: mugga
5 Replies

9. Shell Programming and Scripting

i need to read the last line in a txt file

i'm a beginner in shell and i have a txt file that is updating every second or msec so i need a program to read the last line of this txt file is this possible to do? (5 Replies)
Discussion started by: _-_shadow_-_
5 Replies

10. UNIX for Dummies Questions & Answers

How to read last line of a txt file?

I need to read the last file for a particular day, such as, "Jun 13" because the CSV file is cumulative for the entire day, so I don't want all the previous files, I just want the last file, for that day. I ran an 'ls -al | grep "June 13" > myLs.txt' (simplified) to list all files from that day.... (2 Replies)
Discussion started by: yongho
2 Replies
Login or Register to Ask a Question