|
|
Sponsored Content
Top Forums
Shell Programming and Scripting
file manipulation using nawk
Post 302716345 by sdosanjh on Tuesday 16th of October 2012 08:36:39 AM
10-16-2012
Quote:
Code:
san:/tmp> head -2 f1 TSCparser1 1irons1 1 EMEA_01 -- 5 gaps (7647450 missing messages), 0 seq no resets TSCparser12 1irons1 1 SPAIN_01 -- 3 gaps (43242430 missing messages), 0 seq no resets
Code:
san:/tmp> nawk 'FNR==NR{a[$1,$2,$4]=$6;next}{if(a[$1,$2,$4] != ""){s=($6-a[$1,$2,$4]);$6=0;print $0", Total "s" times gapped in past 1 hr."}}' OFS=" " f2 f1
TSCparser1 1irons1 1 EMEA_01 -- 0 gaps (7647450 missing messages), 0 seq no resets, Total 5 times gapped in past 1 hr.
TSCparser12 1irons1 1 SPAIN_01 -- 0 gaps (43242430 missing messages), 0 seq no resets, Total 3 times gapped in past 1 hr.Last edited by sdosanjh; 10-16-2012 at 09:41 AM..
|
|
10 More Discussions You Might Find Interesting
1. UNIX for Advanced & Expert Users
Hi,
I want to search particular pattern and splitting the file in to multiple files. (Splitted files may be more than 150). It got splitted upto 20 files after that, I got some error.
nawk: filename.21 makes too many open files.
input record number 654, file xxxxxxx
Can u guide me to... (1 Reply)
Discussion started by: sharif
1 Replies
2. Shell Programming and Scripting
i'm new to shell scripting and have a problem please help me
in the script i have a nawk block which has a variable count
nawk{
.
.
.
count=count+1
print count
}
now i want to access the value of the count variable outside the awk block,like..
s=`expr count / m`
(m is... (5 Replies)
Discussion started by: saniya
5 Replies
3. Shell Programming and Scripting
Hi all, I'm new at forum, I cant find an answer to my problem so ,
I need a file which has pipe as a file separator and I need to add a column to a file in the third column I write this code but it s not enough ,
cat allproblems | nawk'\
BEGIN { FS:"|" } {print $3 $4 $5, ????} '
... (7 Replies)
Discussion started by: circuitman06
7 Replies
4. Shell Programming and Scripting
While i am trying to execute nawk in korn shell iam getting this error.
nawk: can't open file $directory../../../filename.
When the file is in home directory it is executing. But its not able to find file in other directory.
Thanks (2 Replies)
Discussion started by: Diddy
2 Replies
5. Shell Programming and Scripting
Hello,
Hope you are doing fine. I have a file in following format. I only want to process the data inside the section that comes after #DATE,CODE,VALUE
#ITEMS WITH CORRECTIONS
.......
#DATE,CODE,VALUE
2011-08-02, ID1, 0.30
2011-08-02, ID2, 0.40
2011-08-02, ID3, 0.50
......
Means... (3 Replies)
Discussion started by: srattani
3 Replies
6. Shell Programming and Scripting
Hi all, I have a file with records that look something like this,
"Transaction ID",Date,Email,"Card Type",Amount,"NETBANX Ref","Root Ref","Transaction Type","Merchant Ref",Status,"Interface ID","Interface Name","User ID"
nnnnnnnnn,"21 Nov 2011 00:10:47",someone@hotmail.co.uk,"Visa... (2 Replies)
Discussion started by: dazedandconfuse
2 Replies
7. UNIX for Dummies Questions & Answers
Hi,
I am looking for an awk script which should help me to meet the following requirement:
File1 has records in following format
INF: FAILEd RECORD AB1234
INF: FAILEd RECORD PQ1145
INF: FAILEd RECORD AB3215
INF: FAILEd RECORD AB6114
............................ (2 Replies)
Discussion started by: mintu41
2 Replies
8. Shell Programming and Scripting
Hi ,
I have a simple text file with contents as below:
12345678900 971,76 4234560890
22345678900 5971,72 5234560990
32345678900 71,12 6234560190
the new csv-file should be like:
Column1;Column2;Column3;Column4;Column5
123456;78900;971,76;423456;0890... (9 Replies)
Discussion started by: FreddyDaKing
9 Replies
9. Shell Programming and Scripting
Hi,
I am confused how to proceed firther please find the problem below:
Input Files:
DCIA_GEOG_DATA_OCEAN.TXT
DCIA_GEOG_DATA_MCRO.TXT
DCIA_GEOG_DATA_CVAS.TXT
DCIA_GEOG_DATA_MCR.TXT
Output File Name: MMA_RFC_GEOG_NAM_DIM_LOD.txt
Sample Record(DCIA_GEOG_DATA_OCEAN.TXT):(Layout same for... (4 Replies)
Discussion started by: Arun Mishra
4 Replies
10. Shell Programming and Scripting
Hi.. i am running nawk scripts on solaris system to get records of file1 not in file2 and find duplicate records in a while with the following scripts -compare
nawk 'NR==FNR{a++;next;} !a {print"line"FNR $0}' file1 file2duplicate - nawk '{a++}END{for(i in a){if(a-1)print i,a}}' file1in the middle... (12 Replies)
Discussion started by: Abhiraj Singh
12 Replies
LEARN ABOUT CENTOS
grub-render-label
GRUB-RENDER-LABEL(1) User Commands GRUB-RENDER-LABEL(1) NAME
grub-render-label - generate a .disk_label for Apple Macs. SYNOPSIS
grub-render-label [OPTION...] [OPTIONS] DESCRIPTION
Render Apple .disk_label. -b, --bgcolor=COLOR use COLOR for background -c, --color=COLOR use COLOR for text -f, --font=FILE use FILE as font (PF2). -i, --input=FILE read text from FILE. -o, --output=FILE set output filename. Default is STDOUT -t, --text=STRING set the label to render -v, --verbose print verbose messages. -?, --help give this help list --usage give a short usage message -V, --version print program version Mandatory or optional arguments to long options are also mandatory or optional for any corresponding short options. REPORTING BUGS
Report bugs to <bug-grub@gnu.org>. SEE ALSO
The full documentation for grub-render-label is maintained as a Texinfo manual. If the info and grub-render-label programs are properly installed at your site, the command info grub-render-label should give you access to the complete manual. grub-render-label (GRUB) 2.02-2ubuntu8.3 July 2018 GRUB-RENDER-LABEL(1)