Need help to understand Awk code. Post: 302511751

Sponsored Content

Top Forums Shell Programming and Scripting Need help to understand Awk code. Post 302511751 by nua7 on Thursday 7th of April 2011 12:55:40 PM

04-07-2011

Registered User

Need help to understand Awk code.

Hi Guys,
Can someone please explain this code to me. I could figure out it's adding and comparing two fields but I am not sure which ones.

Code:

sort -t"|" -k3.1 /tmp/mpcashqc.xtr| awk -F"|" '{CHECKAMT[$2]+=$3;BATCHTOT[$2]=$4;\
items[$2]++}END{for(i in CHECKAMT) if (CHECKAMT[i]!=BATCHTOT[i]) printf("%s|%0.2f|%0.2f|%s \n"),i,CHECKAMT[i],\
BATCHTOT[i],items[i]}'|sort >/tmp/tmpcashqc.btot.errors

Following is the format of mpcashqc.xtr

Code:

20110406|M095800|168.8|15419.43|135|IS00001006|20110406
20110406|M095800|168.8|15419.43|135|IS00001006|20110406
20110406|M095001|159.9|36135.04|249|IS00001153|20110406
20110406|M095016|35.9|35365.46|250|IS00002230|20110406
20110406|M095010|126.2|33721.09|249|IS00002494|20110406
20110406|M095017|159.9|35033.71|250|IS00002763|20110406
20110406|M095007|116|35818.03|250|IS00002947|20110406
20110406|M095025|92|11609.16|78|IS00002962|20110406

nua7

View Public Profile for nua7

Find all posts by nua7

9 More Discussions You Might Find Interesting

1. UNIX for Advanced & Expert Users

Code Understand ?

Hey, Could you explain me what this code is doing ? For example: $i has value 9 $1 is the name of the file say FILEBkUp while do if $1.`/bin/expr $i - 1` ] then mv -f $1.`/bin/expr $i - 1` $1.$i fi i=`/bin/expr $i - 1` done Thanks...

2. UNIX for Dummies Questions & Answers

unable to understand a awk code

i am not able to understand the following code for awk: $awk -F"|" '{ kount++} >END { for (desig in kount) > print desig,kount }' emp.list the input file i.e. emp.list is :: 3432| p.k.agrwal |g.m |sales 4566|g.l.sharma |director|production 3433|r shah | g.m | production...

3. Shell Programming and Scripting

Don't understand how RS functions in awk

I learn using RS in awk to extract portion of file in this forum which is wonderful solution to the problem. However, I don't understand how exactly it operates. I don't quite understand the mechanism behind how searching for /DATA2/ can result in extracting the whole section under "DATA2" ...

4. Shell Programming and Scripting

help can't understand the code

Hi All, Good day, i'm just wondering what is the meaning of this code? COUNT_EXTRACTED_FILE=`${ECHO_CMD} "${SE_IN_PATH}${SE_IN_FILE}" | ${AWK_CMD} -F"__" '{print $2}'` Thanks, -niks(newbie)

5. UNIX for Dummies Questions & Answers

AWK - Hard to understand for me

Hi All, I have googled and spent few hours to understand about AWK usage... But still not very much clear.... Upto my understanding 'AWK' deals with files... It reads the file takes it as a input process it and gives output or writes the output to an another file... >> Please correct me...

6. UNIX for Dummies Questions & Answers

Trying to understand a complex bit of code

Hi, To re-introduce myself, I'm a router guy trying to learn some scripting from the examples in my work place... In a ksh script, one of the script guys wrote the following and I am trying to understand it. I'm hoping someone can explain it to me. The script flow enters a case structure....

7. UNIX for Dummies Questions & Answers

Unable to understand awk script.

Hi below is the samll awk script which i am not able to understand properly. here a bit confusion in 2nd line for me 1. why *\ is not used before . in second line as it was used in first line *\$*\. */ 2. why always \ is used in every first line 3. is there any specific meaning...

8. UNIX for Dummies Questions & Answers

help me to understand this code

Hi guys can you please help me to understand this code . tmpArray=(${line//=/ }) Please next time open a new thread in the appropriate forum and use code tags

9. UNIX for Beginners Questions & Answers

Help understand awk command

Help understand awk command This command converts the column values to rows. Command: awk -s1=" " '{S=S?S OFS s1 $0 s1:s1 $0 s1} END{print S}' OFS=, Input_file Example: 1 2 3 is converted to: 1, 2, 3 Can anyone please help me understand this command? Please use code tags when...

LEARN ABOUT DEBIAN

rackdiag

NWDIAG(1)						      General Commands Manual							 NWDIAG(1)

NAME

       rackdiag - generate rack-structure-diagram image file from spec-text file.

SYNOPSIS

       rackdiag [options] files

DESCRIPTION

       This manual page documents briefly the rackdiag commands.

       rackdiag is generate sequence-diagram image file from spec-text file.

OPTIONS

       These  programs	follow	the  usual  GNU  command  line	syntax, with long options starting with two dashes (`-').  A summary of options is
       included below.	For a complete description, see the Info files.

       -h, --help
	      show this help message and exit.

       --version
	      show program's version number and exit.

       -a, --antialias
	      Pass diagram image to anti-alias filter.

       -c FILE, --config=FILE
	      read configurations from FILE.

       -o FILE
	      write diagram to FILE.

       -f FONT, --font=FONT
	      use FONT to draw diagram.

       -T TYPE
	      Output diagram as TYPE format.

SEE ALSO

       The programs are documented fully by
       http://blockdiag.com/en/nwdiag/

AUTHOR

       rackdiag was written by Takeshi Komiya <i.tkomiya@gmail.com>

       This manual page was written by Kouhei Maeda <mkouhei@palmtb.net>, for the Debian project (and may be used by others).

								   June 11, 2011							 NWDIAG(1)