Sponsored Content
Top Forums Shell Programming and Scripting What is wrong with my awk command? Post 302982485 by SkySmart on Thursday 29th of September 2016 10:59:46 AM
Old 09-29-2016
unfortuntely, none of the suggested commands work.

i need to be able to specify the column to look into. most columns are counted from left to right. however, due to spaces/tabs or formatting differences in files, one may want to grab a column based on the count of right to left.

The solution i need should be able to take a regular numerical value AND also a value like "(NF-whateverNUmber)" which means, count from right to left.

The full data file looks like this:

Code:
costingintegration.ExceptionLogEntry     query         {"_id": 1, "retryFlag": {"$ne": 1}}            1     3778     3778      3778    n/a          3778
costingintegration.negotiatedProductCosts   query         {"$and": [{"season": 1}, {"year": 1}]}            9      138      735       410    n/a          3696
costingintegration.negotiatedProductCosts   query         {"brand": 1, "season": 1, "year": 1}              6      109     2447       534    n/a          3208
costingintegration.$cmd            count         {"costType": 1, "season": 1, "year": 1}           2     1151     1536      1343    n/a          2687
costingintegration.PrimaryCost        query         {"season": 1, "year": 1}                    2      271     1905      1088    n/a          2176
costingintegration.negotiatedProductCosts   getmore       {"$and": [{"season": 1}, {"year": 1}]}           11      104      353       148    n/a          1630
masteritem.$cmd      findandmodify    {"_id": 1}                 1     1451     1451      1451    n/a          1451
costingintegration.$cmd            count         {"season": 1, "year": 1}                    1     1012     1012      1012    n/a          1012
costingintegration.PrimaryCost        query         {"costType": 1, "season": 1, "year": 1}           1      500      500       500    n/a          500
costingintegration.PrimaryCost        getmore       {"bomCCNumber": 1, "season": 1, "year": 1}                      1      252      252       252    n/a          252
planningservice.targets            query         {"ccId": 1, "inDCDate": {"$ne": 1}, "season": 1, "year": 1}           1      160      160       160    n/a          160
costingintegration.$cmd            count         {"brand": 1, "season": 1, "year": 1}              1      136      136       136    n/a          136

in other words, based on the log file, sometimes, i may need the value of COLUMN to be "4" meaning grab column $4. Or if the format of the log is unusual, i may need to say, grab the 3rd column from the right. so essentially, i need to be able to specify:

Code:
COLUMN=4
or
COLUMN='(NF-3)'


Last edited by SkySmart; 09-29-2016 at 12:06 PM..
 

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
cal(1)							      General Commands Manual							    cal(1)

NAME
cal - Displays a calendar SYNOPSIS
cal [month [year]] STANDARDS
Interfaces documented on this reference page conform to industry standards as follows: cal: XCU5.0 Refer to the standards(5) reference page for more information about industry standards and associated tags. OPTIONS
None OPERANDS
Names the month for which you want the calendar. It can be a number between 1 and 12 for January through December, respectively. If month is not specified, cal displays a calendar for the entire year, unless year is also omitted. Names the year for which you want the calen- dar. Because cal can display a calendar for any year from 1 to 9999, enter the full year rather than just the last two digits. If year is not specified, cal uses the current year. If no operands are specified, cal displays a calendar for the current month. DESCRIPTION
The cal command writes to standard output a Gregorian calendar for the specified year or month. For historical reasons, the cal command's Gregorian calendar is discontinuous. The display for September 1752 (cal 9 1752) jumps from Wednesday the 2nd to Thursday the 14th. The cal command checks the LC_TIME environment variable and uses the correct headers for the current locale. If LC_TIME is not set, cal checks the value of LANG. If neither variable is set, you receive English headers. EXIT STATUS
The following exit values are returned: Successful completion. An error occurred. EXAMPLES
To display a calendar for February 1990, enter: cal 2 1990 To display a calendar for the year 84 A.D., enter: cal 84 To display a calendar for the current month, enter: cal ENVIRONMENT VARIABLES
The following environment variables affect the execution of *cmd*: Provides a default value for the internationalization variables that are unset or null. If LANG is unset or null, the corresponding value from the default locale is used. If any of the internationalization vari- ables contain an invalid setting, the utility behaves as if none of the variables had been defined. If set to a non-empty string value, overrides the values of all the other internationalization variables. Determines the locale for the interpretation of sequences of bytes of text data as characters (for example, single-byte as opposed to multibyte characters in arguments). Determines the locale for the for- mat and contents of diagnostic messages written to standard error. Determines the format and contents of the calendar. Determines the location of message catalogues for the processing of LC_MESSAGES. Determines the time zone used to calculate the value of the current month. SEE ALSO
Commands: date(1) Files: locale(4) Standards: standards(5) Command and Shell User's Guide cal(1)
All times are GMT -4. The time now is 06:03 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy