Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: awk printf help
Top Forums UNIX for Beginners Questions & Answers awk printf help Post 303044892 by RudiC on Saturday 7th of March 2020 04:44:37 PM
Old 03-07-2020
Try
Code:
awk -v"DT=$(date)" '
       {c[$1"\t"$7]++
       }

END    {for (x in c)    if (c[x]>3)    printf "[%s]\tfrom %s (%d)\n", DT, x, c[x]
       }
' file
[07.03.20 22:42]    from 120.236.xx.xxx    /index (12)
[07.03.20 22:42]    from 120.231.xx.xxx    /index (7)
[07.03.20 22:42]    from 120.230.xx.xxx    /index (4)

Feel free to adapt date's output format to taste.
 

10 More Discussions You Might Find Interesting

1. UNIX for Advanced & Expert Users

awk printf problem

Hi Friends, Can anyone guide me how to compute sum of column4 from the below file x using awk command? when i do using awk I'm getting sum 7482350198352648.000000 which is not accurate. $ cat x 56,232,dfgjkhdfj,,56,anand 56,22,dfgjkhdfj,7482347823453123.97834 ,56,Khan 56,23,dfgjkhdfj, ... (6 Replies)
Discussion started by: krishna
6 Replies

2. UNIX for Dummies Questions & Answers

AwK printf question

Hi, Does anyone know a easy way to printf $3,$4, ... all the way to the last field in the file? I will need to modify $1 and $2 and then printf modified $1 and $2 and the rest of the fields(which are not changed). I know I can use NF as the total number of field. Do I use a for next statement to... (4 Replies)
Discussion started by: whatisthis
4 Replies

3. Shell Programming and Scripting

printf in awk

Hi friends.. I am confused about awk printf option.. I have a comma separated file 88562848,21-JAN-08,2741079, -1188,-7433,TESTING 88558314,21-JAN-08,2741189, -1273,-7976,TESTING and there is a line in my script ( written by someone else) What is the use of command? I guess... (10 Replies)
Discussion started by: clx
10 Replies

4. Shell Programming and Scripting

awk and printf

echo $bbsize 1.5 echo $fillpercent .95 echo $bbsize | awk '{printf "%.2f\n",$0*$fillpercent}' 2.25 echo $bbsize | awk '{printf "%.2f\n",$0*.95}' 1.42 1.42 is what I'm expecting... echo $blocksize 4096 echo $bbsize | awk '{printf "%.2f\n",$0*$blocksize}' 2.25 echo $bbsize |... (3 Replies)
Discussion started by: xgringo
3 Replies

5. Shell Programming and Scripting

IF and awk/printf

Hi Friends, Scripting newb here. So I'm trying to create a geektool script that uses awk and printf to output certain fields from top (namely command, cpu%, rsize, pid and time, in that order). After much trial and error, I've pretty much succeeded, with one exception. Any process whose name... (3 Replies)
Discussion started by: thom.mattson
3 Replies

6. Shell Programming and Scripting

AWK printf help

Target file contains short text (never more than 1 line) and filenames. The format is, e.g.,: TEXT1 filename1 TEXT2 TEXT3 filename3dddd filename3dddd TEXT4 filename4 TEXT5 filename5dddd filename5dddd filename5 where dddd is a random 4-digit whole number. Desired output: (4 Replies)
Discussion started by: uiop44
4 Replies

7. Shell Programming and Scripting

awk with printf

Hi, I am using the following code to assign a count value to a variable. But I get nothing. Do you see anything wrong here. I am new to all this. $CTR=`remsh $m -l $MACHINES{$m} -n cat $output | grep -v sent | grep \"$input\" | sort -u | awk '{print $5}'`; Upto sort - u it's... (2 Replies)
Discussion started by: nurani
2 Replies

8. Shell Programming and Scripting

printf format with awk

Hello Here is an easy one Data file 12345 (tab) Some text (tab) 53.432 23456 (tab) Some longer text (tab) 933.422 34567 (tab) Some different text (tab) 29.309 I need to awk these three tab-delimited columns so that the first two are unchanged (unformatted) and the third shows two decimal... (1 Reply)
Discussion started by: palex
1 Replies

9. Shell Programming and Scripting

Use of awk and printf - help needed

I have a very large file with more than 500,000 lines of dated events. The first field contains the date/time in the following format: 20120727-files.files:20120727090044 where the first 8 numbers represent yyyymmdd. The last set of numbers represent yyyy/mm/dd/hh:mm:ss I would like to... (4 Replies)
Discussion started by: LDHB2012
4 Replies

10. Shell Programming and Scripting

awk printf dillemma

Please help me format this file: Source file looks like this, there are three columns, separated by space. First column has varrying width: 1 248105240 W25_2013 10 248103710 W06_2013 100 248103710 W06_2013 1000 248103710 W06_2013 I need to transform the file into a fixed width per column.... (1 Reply)
Discussion started by: tamahomekarasu
1 Replies

LEARN ABOUT DEBIAN

lurker-search

LURKER-SEARCH(1)					      General Commands Manual						  LURKER-SEARCH(1)

NAME

       lurker-search -- searches for messages in a lurker database

SYNOPSIS

       lurker-search [-c <config-file>]  [-k <keyword>]  [-d -f -i -v -q]  [<terms>*]

DESCRIPTION

       lurker-search searches a lurker database the same way as the web interface. It can output summary information and delete messages.

OPTIONS

       -c config-file
		 Use this config file for lurker settings.

       -k keyword
		 Tag the matching messages with this keyword.

       -d	 Delete the messages found by this search

       -f	 Don't prompt before deleting

       -i	 Command line paramers are not search terms, but message IDs.

       -v	 Output message summary information

       -q	 Don't output message ids or status

SEARCH TERMS

       Lurker-search accepts these keywords for searching:

       -xxx	 select messages which do NOT match this term

       id:xxx	 select a message by the Message-ID field

       rt:xxx	 select messages which reply to the chosen Message-ID

       th:xxx	 select messages included in this thread

       ml:xxx	 select messages in this mailing list

       gr:xxx	 select messages in this mailing list group

       au:xxx	 select messages with this term in the author fields

       sb:xxx	 select messages with this word in the subject

       lang:xxx  select messages in this language

SEE ALSO

       lurker-index(1), lurker-prune(1), lurker-params(1), lurker-list(1)

       lurker documentation on http://lurker.sourceforge.net/

COPYRIGHT

       Copyright (C) 2002: Wesley W. Terpstra <terpstra@users.sourceforge.net>

       This  program  is free software; you can redistribute it and/or modify it under the terms of the GNU General Public License as published by
       the Free Software Foundation; version 2.

       This program is distributed in the hope that it will be useful, but WITHOUT ANY	WARRANTY;  without  even  the  implied	warranty  of  MER-
       CHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU General Public License for more details.

       You  should  have received a copy of the GNU General Public License along with this program; if not, write to the Free Software Foundation,
       Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA.

BUGS

       Before reporting a bug, please confirm that the bug you found is still present in the latest official release.  If  the	problem  persists,
       then send mail with instructions describing how to reproduce the bug to <lurker-users@lists.sourceforge.net>.

																  LURKER-SEARCH(1)
All times are GMT -4. The time now is 07:33 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy