awk to print specific line in file based on criteria Post: 302982047

Sponsored Content

Top Forums Shell Programming and Scripting awk to print specific line in file based on criteria Post 302982047 by Don Cragun on Thursday 22nd of September 2016 03:31:54 PM

09-22-2016

Registered User

Hi cmccabe,
If I correctly understand your specification, you could also try this alternative using your original input field separator specification:

Code:

awk -F"\"[,:]* *\"*" '
{	for(i = 2; i < NF - 3; i++)
		if($i       == "path" &&
		   $(i + 2) == "plugin" &&
		   $(i + 3) == "/rundb/api/v1/plugin/49/")
			print $(i + 1)
}
' file

(and I must say that that is a nicely constructed field separator ERE). You could simplify it a little bit using single quotes to avoid needing to escape the double quotes: -F'"[,:]* *"*'.

Hi R. Singh,
Note that using -F"[\"|:|,]" specifies that any ", |, :, |, or , character is to be treated as a field separator because every character in a bracket expression (other than the backslash used to escape a double-quote in a shell double-quoted string) is a match. There is no alternation in a bracket expression. You could get the same effect (unless you really wanted | to be a field separator) with -F'[":,]' (using a matching bracket expression) or with -F'"|:|,' (using alternation without a bracket expression). And, if there were any | characters in the input, your expression would interpret them as field separators instead of as data.

Last edited by Don Cragun; 09-23-2016 at 05:13 AM.. Reason: Fix typo: s/needed/needing/

These 2 Users Gave Thanks to Don Cragun For This Post:

Don Cragun

View Public Profile for Don Cragun

Find all posts by Don Cragun

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

To print a specific line in Shell or awk.

Hi, I want to echo the 15th line from a file named as abc.txt, also i want to echo only the values in that line not the line number. Thanks in advance:)

2. Shell Programming and Scripting

Append specific lines to a previous line based on sequential search criteria

I'll try explain this as best I can. Let me know if it is not clear. I have large text files that contain data as such: 143593502 09-08-20 09:02:13 xxxxxxxxxxx xxxxxxxxxxx 09-08-20 09:02:11 N line 1 test line 2 test line 3 test 143593503 09-08-20 09:02:13...

3. Shell Programming and Scripting

Extract data based on specific search criteria

I have a huge file (about 2 millions records) contains data separated by “,” (comma). As part of the requirement, I can't change the format. The objective is to remove some of the records with the following condition. If the 23rd field on each line start with 302 , I need to remove that from the...

4. Shell Programming and Scripting

AWK Print Line If Specific Character Is Matched

Hello, I have a file as such: FFFFFFF6C000000 225280 225240 - - rwxs- FFFFFFFF79C00000 3240 3240 - - rwxs- FFFFFFFF7A000000 4096 4096 - - rwxs- FFFFFFFF7A400000 64 64 ...

5. Shell Programming and Scripting

Passing parameter in sed or awk commands to print for the specific line in a file

Hi, I am trying to print a specific line in a file through sed or awk. The line number will be passed as a parameter from the previous step. My code looks as below. TEMP3=`sed -n '$TEMP2p' $FILEPATH/Log.txt` $TEMP2, I am getting from the previous step which is a numerical value(eg:3). ...

6. Shell Programming and Scripting

Extract error records based on specific criteria from Unix file

Hi, I look for a awk one liner for below issue. input file ABC 1234 abc 12345 ABC 4567 678 XYZ xyz ght 678 ABC 787 yyuu ABC 789 7890 777 zxr hyip hyu mno uii 678 776 ABC ty7 888 All lines should be started with ABC as first field. If a record has another value for 1st...

7. Shell Programming and Scripting

Only print specific xml values that meet two criteria in python

I have a large XML file that I want to parse, and only print one specific value if two values are met. This is the code so far: #!/usr/local/bin/python import xml.etree.ElementTree as ET tree = ET.parse('onedb-dhcp.xml') root = tree.getroot() # This successfully gets all...

8. Shell Programming and Scripting

Need a Linux command for find/replace column based on specific criteria.

I'm new to shell programming, I have a huge text file in the following format, where columns are separated by single space: ACA MEX 4O_ $98.00 $127.40 $166.60 0:00 0:00 0 ; ACA YUL TS_ $300.00 $390.00 $510.00 0:00 0:00 0 ; ACA YYZ TS_ $300.00 $390.00 $510.00 0:00 0:00 0 ; ADZ YUL TS_ $300.00...

9. Shell Programming and Scripting

awk to print line based on two keywords

I am starting to write a multi-line awk and using the file below which is tab-delimited, print only the line with oncomineGeneClass and oncomineVariantClass and PASS. The script execute but seems to be printing the entire file, not the desired line. Thank you :). file ...

10. Shell Programming and Scripting

Awk/sed/cut to filter out records from a file based on criteria

I have two files and would need to filter out records based on certain criteria, these column are of variable lengths, but the lengths are uniform throughout all the records of the file. I have shown a sample of three records below. Line 1-9 is the item number "0227546_1" in the case of the first...

LEARN ABOUT OPENSOLARIS

mp_registerplugin

MP_RegisterPlugin(3MPAPI)			   Common Multipath Management Library Functions			 MP_RegisterPlugin(3MPAPI)

NAME

       MP_RegisterPlugin - register a plugin with the common library

SYNOPSIS

       cc [ flag... ] file... -lMPAPI [ library... ]
       #include <mpapi.h>

       MP_STATUS MP_RegisterPlugin(MP_WCHAR *pPluginId,
	    MP_CHAR *pFileName);

PARAMETERS

       pPluginId    A  pointer	to the key name shall be the reversed domain name of the vendor followed by a ".", followed by the vendor-specific
		    name for the plugin that uniquely identifies it.

       pFileName    The full path name of the plugin library.

DESCRIPTION

       The MP_RegisterPlugin() function  registers  a  plugin  with  the  common  library.  The  current  implementation  adds	an  entry  to  the
       /etc/mpapi.conf file.

       Unlike  some other APIs, this API is implemented entirely in the common library. It must be called before a plugin is invoked by the common
       library.

       This API does not impact dynamically add or change plugins bound to a running library instance. Instead, it causes an application  that	is
       currently  not using a plugin to access the specified plugin on future calls to the common library. This is generally the behavior expected
       from dynamically loaded modules.

       This API is typically called by a plugin's installation software to inform the common library of the path for the plugin library.

       It is not an error to re-register a plugin. However,  a plugin has only one registration. The first call to deregister a plugin will dereg-
       ister it no matter how many calls to register the plugin have been made.

       A vendor may register multiple plugins by using separate plugin IDs and filenames.

RETURN VALUES

       MP_STATUS_INVALID_PARAMETER

	   The pFileName does not exist.

       MP_STATUS_SUCCESS

	   The operation is successful.

FILES

       /etc/mpapi.conf	  MPAPI library configuration file

ATTRIBUTES

       See attributes(5) for descriptions of the following attributes:

       +-----------------------------+-----------------------------+
       |      ATTRIBUTE TYPE	     |	    ATTRIBUTE VALUE	   |
       +-----------------------------+-----------------------------+
       |Interface Stability	     |Standard:  ANSI  INCITS 412  |
       |			     |Multipath Management API	   |
       +-----------------------------+-----------------------------+
       |MT-Level		     |Safe			   |
       +-----------------------------+-----------------------------+

SEE ALSO

       libMPAPI(3LIB), MP_DeregisterPlugin(3MPAPI), mpapi.conf(4), attributes(5)

       Multipath Management API Version 1.0

SunOS 5.11							    15 Feb 2006 					 MP_RegisterPlugin(3MPAPI)

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

To print a specific line in Shell or awk.

Discussion started by: tushar_tus

2. Shell Programming and Scripting

Append specific lines to a previous line based on sequential search criteria

Discussion started by: jesse

3. Shell Programming and Scripting

Extract data based on specific search criteria

Discussion started by: jaygamini

4. Shell Programming and Scripting

AWK Print Line If Specific Character Is Matched

Discussion started by: PointyWombat