Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: What is wrong with my awk command?
Top Forums Shell Programming and Scripting What is wrong with my awk command? Post 302982477 by SkySmart on Thursday 29th of September 2016 10:22:14 AM
Old 09-29-2016
What is wrong with my awk command?
The below code usually works when the value for the COLUMN variable is numerical. but im in a situation where the number of fields in a file is not definitive. it changes.
but what is static is that the value i want to retrieve from the log is 3 fields from the last field. which is what i attempted to grab with the '(NF-3)'

data:

Code:
costingi.PrimaryCost query {"costType": 1, "season": 1, "year": 1} 1 500 500 500 n/a 1
planningservice.targets query {"ccId": 1, "inDCDate": {"$ne": 1}, "season": 1, "year": 1} 1 160 160 160 n/a 1

code:
Code:
WARN=170
CRIT=200
COLUMN='(NF-3)'

awk -F" " '/query/ && !/nothing/ {if($'$COLUMN' = '$WARN' || $'$COLUMN' = '$CRIT') { print ; w++ } else if($'$COLUMN' = '$CRIT') { print ; c++ } else {o++}} END { printf("%d:OK %d:WARNING %d:CRITICAL\n", o, w, c) }'

However, when i run the above command, it simply outputs everything in the file, instead of just the specific lines that have a value greater than the
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Is anything wrong with this command

Hi All, can anyone tell me what is wrong with this command. tail -f /opt/olr-logs/PaymentGateway.log | grep "DEBUG - Start! AkhtarPaymentGateway - generateChecksum" | awk '{print $13}' | sed 's/,//g'>> abc But I found nothing in the file abc Please do help me.or Provide me some... (8 Replies)
Discussion started by: akhtar.bhat
8 Replies

2. UNIX for Dummies Questions & Answers

AWK command giving wrong input

Hi all, I have a problem with qwk command. i have to check process status and for that i am using command prstat -mvL 1 1 and it gives me the entire output but when i use this command with awk like this: prstat -mvL 1 1 | awk -F" " '{print $1,$15}' to get first and 15th arguments. ... (3 Replies)
Discussion started by: usha rao
3 Replies

3. UNIX for Dummies Questions & Answers

what is wrong with this command?

Hello, I try to using the below command to find out all the datafiles under "sja" direcotory. $ xargs -i find {} -type f -ls < sja /bin/ksh: sja: cannot open so can you tell me what is wrong? Thanks Jerry (3 Replies)
Discussion started by: GreatJerry
3 Replies

4. Emergency UNIX and Linux Support

getting wrong output with AWK command!!!

i have a file which gets appended with 9 records daily and the file keeps growing from then...i use to store the previous day files count in a variable called oldfilecount and current files count as newfilecount.my requirement is that i need to start processing only the new records from the... (3 Replies)
Discussion started by: ganesh_248
3 Replies

5. Shell Programming and Scripting

awk... what is wrong?

Hi there, what is wrong with this? grep ">>" alarms_temp | awk '{print substr($5, 2), $7}' | read var1 var2 echo "$var1" echo "$var2" Both variable are empty, but if i run: grep ">>" alarms_temp | awk '{print substr($5, 2), $7}' I have: 0 9 as a result. (2 Replies)
Discussion started by: marimovo
2 Replies

6. Shell Programming and Scripting

What's wrong with the following command?

Hi all, I'm trying to run the following command to get all files in one directory to another with the files' timestamps preserved, cp -p /logs/dvgbiau/batch/* /logs/dvgbiau/tmp_batch Note that ./batch and ./tmp_batch are two sub-directories under /logs/dvgbiau. The error was,... (1 Reply)
Discussion started by: isaacniu
1 Replies

7. Shell Programming and Scripting

What's wrong with this awk?

ZSCORE=$(awk "BEGIN {if($STDEVIATE>0) {print ZSCORER=$(awk "BEGIN{print (${ALL} - ${AVERAGE}) / ${STDEVIATE}}")}else print "0"}") awk: fatal: division by zero attempted awk: BEGIN {if(0==0) {print ZSCORER=}else print 0} awk: ^ syntax error ALL=9 STDEVIATE=0... (2 Replies)
Discussion started by: SkySmart
2 Replies

8. Shell Programming and Scripting

what's wrong with my awk

echo "abc:bcd" |awk '{split($0,b,":");print "b" is good }' I want to "bcd" is good , anything is wrong with my, please don't change my thought with split, I just want to know what's wrong :o (1 Reply)
Discussion started by: yanglei_fage
1 Replies

9. Shell Programming and Scripting

What's wrong with this awk?

I have a file and if I'm doing following action on that file it's coming up correctly awk -F"," '/DATA_TYPE/ { cnt += $3 } END { print " DATA_TYPE count=" cnt}' inter DATA_TYPE count=19593131 now if I'm changing same AWK, so that now it can accept variable, then it's somehow not working.... (3 Replies)
Discussion started by: manas_ranjan
3 Replies

10. Shell Programming and Scripting

What's wrong with my awk

file1: maximum_delay time: 102.794 ms maximum_delay time: 92.977 ms maximum_delay time: 98.895 ms maximum_delay time: 96.891 ms maximum_delay time: 86.966 ms maximum_delay time: 95.91 ms maximum_delay time: 98.921 ms maximum_delay time: 89.881 ms maximum_delay time: 92.931 ms... (1 Reply)
Discussion started by: yanglei_fage
1 Replies

LEARN ABOUT LINUX

git-column

GIT-COLUMN(1)							    Git Manual							     GIT-COLUMN(1)

NAME

       git-column - Display data in columns

SYNOPSIS

       git column [--command=<name>] [--[raw-]mode=<mode>] [--width=<width>]
		    [--indent=<string>] [--nl=<string>] [--padding=<n>]

DESCRIPTION

       This command formats its input into multiple columns.

OPTIONS

       --command=<name>
	   Look up layout mode using configuration variable column.<name> and column.ui.

       --mode=<mode>
	   Specify layout mode. See configuration variable column.ui for option syntax.

       --raw-mode=<n>
	   Same as --mode but take mode encoded as a number. This is mainly used by other commands that have already parsed layout mode.

       --width=<width>
	   Specify the terminal width. By default git column will detect the terminal width, or fall back to 80 if it is unable to do so.

       --indent=<string>
	   String to be printed at the beginning of each line.

       --nl=<N>
	   String to be printed at the end of each line, including newline character.

       --padding=<N>
	   The number of spaces between columns. One space by default.

AUTHOR

       Written by Nguyen Thai Ngoc Duy <pclouds@gmail.com[1]>

GIT

       Part of the git(1) suite

NOTES

	1. pclouds@gmail.com
	   mailto:pclouds@gmail.com

Git 1.8.5.3							    01/14/2014							     GIT-COLUMN(1)
All times are GMT -4. The time now is 10:41 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy