Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: How to print the "grep" result as specified keyword order?
Top Forums UNIX for Beginners Questions & Answers How to print the "grep" result as specified keyword order? Post 303037632 by RudiC on Thursday 8th of August 2019 08:47:53 AM
Old 08-08-2019
For reading the keywords from file, try grep -f id.txt


For keeping the sequence as given in id.txt, you could write e.g. an awk or perl script. Or try this very inefficient shell (untested):
Code:
while read ID
  do   grep $ID content.xls
  done < id.txt

Don't try with large files, as it scans through the entire content.xls for every single keyword in id.txt
Reading the content.xls file into an associated array indexed by the key value and then printing it according to the keys found in id.txt is left as an exercise for the reader.
This User Gave Thanks to RudiC For This Post:
dineshkumarsrk
 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

grep/cat/more -- search in a txt file and display content from a specific "keyword"

Hi, I have a .txt file Sample: ===================== NEXT HOST ===================== AEADBAS001 ip access-list extended BLA_Incoming_Filter ip access-list extended BLA_Outgoing_Filter access-list 1 permit xxxxxxxxxxxxxx access-list 2 permit xxxxxxxxxxxxxx =====================... (4 Replies)
Discussion started by: I-1
4 Replies

2. UNIX for Dummies Questions & Answers

Explain the line "mn_code=`env|grep "..mn"|awk -F"=" '{print $2}'`"

Hi Friends, Can any of you explain me about the below line of code? mn_code=`env|grep "..mn"|awk -F"=" '{print $2}'` Im not able to understand, what exactly it is doing :confused: Any help would be useful for me. Lokesha (4 Replies)
Discussion started by: Lokesha
4 Replies

3. Shell Programming and Scripting

ls -laR | grep "^-" | awk '{print $9}'| grep "$.txt"

Hi, I don't know hot to make this command work: ls -laR | grep "^-" | awk '{print $9}'| grep "$.txt" It should return the list of file .txt It's important to search .txt at the end of the line, becouse some file name have "txt" in their name but have other extensions (13 Replies)
Discussion started by: DNAx86
13 Replies

4. Shell Programming and Scripting

MEM=`ps v $PPID| grep -i db2 | grep -v grep| awk '{ if ( $7 ~ " " ) { print 0 } else

Hi Guys, I need to set the value of $7 to zero in case $7 is NULL. I've tried the below command but doesn't work. Any ideas. thanks guys. MEM=`ps v $PPID| grep -i db2 | grep -v grep| awk '{ if ( $7 ~ " " ) { print 0 } else { print $7}}' ` Harby. (4 Replies)
Discussion started by: hariza
4 Replies

5. UNIX for Dummies Questions & Answers

Execute "find . -exec grep" in desending Order

Hi Xperts, I've one query for you. Please help me solving this. Below command is taking long time to fetch names of the files which contain string "475193976" because folder contains millions of files. I agree that this is what this function suppose to do. Correct.. But can it be possible... (6 Replies)
Discussion started by: gav_dhiman
6 Replies

6. Shell Programming and Scripting

cat $como_file | awk /^~/'{print $1","$2","$3","$4}' | sed -e 's/~//g'

hi All, cat file_name | awk /^~/'{print $1","$2","$3","$4}' | sed -e 's/~//g' Can this be done by using sed or awk alone (4 Replies)
Discussion started by: harshakusam
4 Replies

7. Solaris

How to check "faulty" or "stalled" print queues - SAP systems?

Hi all, First off, sorry for a long post but I think I have no other option if I need to explain properly what I need help for. I need some advise on how best to check for "faulty" or "stalled/jammed' print queues. At the moment, I have three (3) application servers which also acts as print... (0 Replies)
Discussion started by: newbie_01
0 Replies

8. Shell Programming and Scripting

ps -ef | grep "string1" "string2" " "string3"

Hi all, can any one suggest me the script to grep multiple strings from ps -ef pls correct the below script . its not working/ i want to print OK if all the below process are running in my solaris system. else i want to print NOT OK. bash-3.00$ ps -ef | grep blu lscpusr 48 42 ... (11 Replies)
Discussion started by: steve2216
11 Replies

9. Shell Programming and Scripting

sort, columns, no result! can I print files of "planes"?

hi, please can I ask you for some help? I have data from 3D situation, x y z value I'd like to use gnuplot to generate maps of the value in the planes z=0 to z=1 for example, my file looks like -0,012 0,0060 0,0 0,13972813076023477 -0,012 0,0064319163 4,2894483E-4 ... (1 Reply)
Discussion started by: kocour
1 Replies

10. Shell Programming and Scripting

Bash script - Print an ascii file using specific font "Latin Modern Mono 12" "regular" "9"

Hello. System : opensuse leap 42.3 I have a bash script that build a text file. I would like the last command doing : print_cmd -o page-left=43 -o page-right=22 -o page-top=28 -o page-bottom=43 -o font=LatinModernMono12:regular:9 some_file.txt where : print_cmd ::= some printing... (1 Reply)
Discussion started by: jcdole
1 Replies

LEARN ABOUT DEBIAN

eximstats

EXIMSTATS(8)							       EXIM4							      EXIMSTATS(8)

NAME

       eximstats - generates statistics from Exim mainlog or syslog files.

SYNOPSIS

	eximstats [Output] [Options] mainlog1 mainlog2 ...
	eximstats -merge [Options] report.1.txt report.2.txt ... > weekly_report.txt

   Output:
       -txt
	   Output the results in plain text to STDOUT.

       -txt=filename
	   Output the results in plain text. Filename '-' for STDOUT is accepted.

       -html
	   Output the results in HTML to STDOUT.

       -html=filename
	   Output the results in HTML. Filename '-' for STDOUT is accepted.

       -xls
	   Output the results in Excel compatible Format to STDOUT.  Requires the Spreadsheet::WriteExcel CPAN module.

       -xls=filename
	   Output the results in Excel compatible format. Filename '-' for STDOUT is accepted.

   Options:
       -hnumber
	   histogram divisions per hour. The default is 1, and 0 suppresses histograms. Valid values are:

	   0, 1, 2, 3, 5, 10, 15, 20, 30 or 60.

       -ne Don't display error information.

       -nr Don't display relaying information.

       -nr/pattern/
	   Don't display relaying information that matches.

       -nt Don't display transport information.

       -nt/pattern/
	   Don't display transport information that matches

       -qlist
	   List of times for queuing information single 0 item suppresses.

       -tnumber
	   Display top <number> sources/destinations default is 50, 0 suppresses top listing.

       -tnl
	   Omit local sources/destinations in top listing.

       -t_remote_users
	   Include remote users in the top source/destination listings.

       -include_original_destination
	   Include the original destination email addresses rather than just using the final ones.  Useful for finding out which of your mailing
	   lists are receiving mail.

       -show_dtlist
	   Show the delivery times (DT)for all the messages.

	   Exim must have been configured to use the +deliver_time logging option for this option to work.

	   list is an optional list of times. Eg -show_dt1,2,4,8 will show the number of messages with delivery times under 1 second, 2 seconds, 4
	   seconds, 8 seconds, and over 8 seconds.

       -show_rtlist
	   Show the receipt times for all the messages. The receipt time is defined as the Completed hh:mm:ss - queue_time_overall - the Receipt
	   hh:mm:ss.  These figures will be skewed by pipelined messages so might not be that useful.

	   Exim must have been configured to use the +queue_time_overall logging option for this option to work.

	   list is an optional list of times. Eg -show_rt1,2,4,8 will show the number of messages with receipt times under 1 second, 2 seconds, 4
	   seconds, 8 seconds, and over 8 seconds.

       -byhost
	   Show results by sending host. This may be combined with -bydomain and/or -byemail and/or -byedomain. If none of these options are
	   specified, then -byhost is assumed as a default.

       -bydomain
	   Show results by sending domain.  May be combined with -byhost and/or -byemail and/or -byedomain.

       -byemail
	   Show results by sender's email address.  May be combined with -byhost and/or -bydomain and/or -byedomain.

       -byemaildomain or -byedomain
	   Show results by sender's email domain.  May be combined with -byhost and/or -bydomain and/or -byemail.

       -pattern Description /Pattern/
	   Look for the specified pattern and count the number of lines in which it appears.  This option can be specified multiple times. Eg:

	    -pattern 'Refused connections' '/refused connection/'

       -merge
	   This option allows eximstats to merge old eximstat reports together. Eg:

	    eximstats mainlog.sun > report.sun.txt
	    eximstats mainlog.mon > report.mon.txt
	    eximstats mainlog.tue > report.tue.txt
	    eximstats mainlog.wed > report.web.txt
	    eximstats mainlog.thu > report.thu.txt
	    eximstats mainlog.fri > report.fri.txt
	    eximstats mainlog.sat > report.sat.txt
	    eximstats -merge	   report.*.txt > weekly_report.txt
	    eximstats -merge -html report.*.txt > weekly_report.html

	   o   You can merge text or html reports and output the results as text or html.

	   o   You can use all the normal eximstat output options, but only data included in the original reports can be shown!

	   o   When merging reports, some loss of accuracy may occur in the top n lists.  This will be towards the ends of the lists.

	   o   The order of items in the top n lists may vary when the data volumes round to the same value.

       -charts
	   Create graphical charts to be displayed in HTML output.  Only valid in combination with -html.

	   This requires the following modules which can be obtained from http://www.cpan.org/modules/01modules.index.html

	   GD
	   GDTextUtil
	   GDGraph

	   To install these, download and unpack them, then use the normal perl installation procedure:

	    perl Makefile.PL
	    make
	    make test
	    make install

	   On Debian GNU/Linux you can use "apt-get install libgd-perl libgd-text-perl libgd-graph-perl" instead.

       -chartdirI <dir>
	   Create the charts in the directory <dir>

       -chartrelI <dir>
	   Specify the relative directory for the "img src=" tags from where to include the charts

       -emptyok
	   Specify that it's OK to not find any valid log lines. Without this we will output an error message if we don't find any.

       -d  Debug flag. This outputs the eval()'d parser onto STDOUT which makes it easier to trap errors in the eval section. Remember to add 1 to
	   the line numbers to allow for the title!

DESCRIPTION

       Eximstats parses exim mainlog and syslog files to output a statistical analysis of the messages processed. By default, a text analysis is
       generated, but you can request other output formats using flags. See the help (-help) to learn about how to create charts from the tables.

AUTHOR

       There is a web site at http://www.exim.org

TO DO

       This program does not perfectly handle messages whose received and delivered log lines are in different files, which can happen when you
       have multiple mail servers and a message cannot be immediately delivered. Fixing this could be tricky...

       Merging of xls files is not (yet) possible. Be free to implement :)

perl v5.14.2							    2014-07-24							      EXIMSTATS(8)
All times are GMT -4. The time now is 10:32 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy