AWK/SED print if 2nd character in a column is greater than 0


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting AWK/SED print if 2nd character in a column is greater than 0
# 1  
Old 08-18-2011
AWK/SED print if 2nd character in a column is greater than 0

We have an access log where column 8 displays the time in seconds like below:
Code:
Tj8nQAoNgwsAABov9cIAAAFL - 10.13.131.80 - - [07/Aug/2011:17:01:04 -0700] (0) -  "GET /aaaaa/bbbb/bbbb

where column 8 is printed (0). We are trying to find how many entries are there that has column 8 greater than 0.

Remember $8 is (0) and not 0. It has parenthesis around the number.
I tried various commands like below which did not work. Some help might be greatly appreciated.
Code:
awk '{print "time=",($8 != "(0)")}' access.log
awk '{print "time="$8 !~/^(0)$/}' access.log
awk '{print $8 !~ /(0)/}' access.log


Last edited by Franklin52; 08-19-2011 at 03:04 PM.. Reason: Please use code tags for data and code samples, thank you
# 2  
Old 08-18-2011
Code:
awk '$8!~"(0)"' access.log

This User Gave Thanks to bartus11 For This Post:
# 3  
Old 08-18-2011
sdnlfkdnlvk

Last edited by bvsa; 08-18-2011 at 06:50 PM..
# 4  
Old 08-18-2011
Don't hijack other people's threads. Post your problem as a new thread.
# 5  
Old 08-18-2011
That helped me to some extent. Thank you. Is there a way we can print rows whose $8 is greater than 10 secs. $8 is time in seconds, format = (n), parenthesis included.

I did a awk '$8 >"(10)"' access.log which also printed rows < (10) value. Any ideas?
# 6  
Old 08-18-2011
Code:
awk '{x=$8;gsub("[()]","",x);if (x>10) print}' access.log

Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

awk or sed to print the character from the previous line after the regexp match

Hi All, I need to print the characters in the previous line just before the regular expression match Please have a look at the input file as attached I need to match the regular expression ^ with the character of the previous like and also the pin numbers and the output file should be like... (6 Replies)
Discussion started by: kshitij
6 Replies

2. Shell Programming and Scripting

awk Print New Column For Every Two Lines and Match On Multiple Column Values to print another column

Hi, My input files is like this axis1 0 1 10 axis2 0 1 5 axis1 1 2 -4 axis2 2 3 -3 axis1 3 4 5 axis2 3 4 -1 axis1 4 5 -6 axis2 4 5 1 Now, these are my following tasks 1. Print a first column for every two rows that has the same value followed by a string. 2. Match on the... (3 Replies)
Discussion started by: jacobs.smith
3 Replies

3. Shell Programming and Scripting

awk to substitute third column if first column is greater than interest

A file 2400 2800 PSC000289 3200 3896 PCS000289 3333 3666 PCS000221 222 1000 PCS000222 3299 3600 PSC000289 Question is while if third column is PCS000289 and first column should be greater than 3000, then replace PCS000289 by YES, remaining the others column same. ... (1 Reply)
Discussion started by: cdfd123
1 Replies

4. UNIX for Dummies Questions & Answers

Use sed on column (csv) file if data in colmns is greater > than?

I have a data file that has 14 columns. I cannot use awk or perl but sed is installed on my host. I would like to delete a line if fields 10, 11 or twelve is greater than 999.99. How is this done using sed? :wall: sed '/^*,*,*,*,*,*,*,*,*,*,*,*,*,*,/d' infile 1 2 3 4 ... (2 Replies)
Discussion started by: Chris Eagleson
2 Replies

5. Shell Programming and Scripting

Greping the column with a value greater than 50 with awk

Hi All, I am running a command from a remote server using ssh to different servers. I will get a output like below with 4 columns. I want to grab line which is having a coulmn which grate than or equal to 50. How can I do it with Awk or sed ??. I add a space to first row with sed 's/::/:: /g' to... (4 Replies)
Discussion started by: raghin
4 Replies

6. Shell Programming and Scripting

comparing column of two different files and print the column from in order of 2nd file

Hi friends, My file is like: Second file is : I need to print the rows present in file one, but in order present in second file....I used while read gh;do awk ' $1=="' $gh'" {print >> FILENAME"output"} ' cat listoffirstfile done < secondfile but the output I am... (14 Replies)
Discussion started by: CAch
14 Replies

7. Shell Programming and Scripting

sed or awk to print 2nd last word

Hi, I have a file which has the following /usr/new/xyz/abc /us1/neb/yxr/def /usr/bin/cloud1/fgh /net/bin1/txt1/kdq I want to do something like this /usr/new/xyz/abc xyz /us1/neb/yxr/def yxr /usr/bin/cloud1/fgh cloud1 /net/bin1/txt1/kdq txt1 I need to add the 2nd last word to the... (3 Replies)
Discussion started by: matbrow
3 Replies

8. Homework & Coursework Questions

Problem with awk,not able print the file that is greater than 3000 bytes.

My Script: #!/bin/sh date=`date +%y%m%d -d"1 day ago"` in_dir=/vis/logfiles/to_solmis cp `grep -il ST~856~ $inbound_dir/*$date*` /vis/sumit/in_ASN/ for i in /vis/sumit/in_ASN/* do mkdir -p /vis/sumit/inboundasns.$date cp `echo $i`... (1 Reply)
Discussion started by: shrima.pratima
1 Replies

9. Linux

How to replace the 2nd character in a string using sed?

Hi, i have string var1=NN. Based on conditions, i have to change this first N to Y or second N to Y and send the details to other process. How to do that? This is a linux machine. Thanks, Selva (1 Reply)
Discussion started by: bharathappriyan
1 Replies

10. Shell Programming and Scripting

print a file with one column having fixed character length

Hi guys, I have tried to find a solution for this problem but couln't. If anyone of you have an Idea do help me. INPUT_FILE with three columns shown to be separated by - sign A5BNK723NVI - 1 - 294 A7QZM0VIT - 251 - 537 A7NU3411V - 245 - 527 I want an output file in which First column... (2 Replies)
Discussion started by: smriti_shridhar
2 Replies
Login or Register to Ask a Question