Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: awk to match condition and print in columns
Top Forums UNIX for Beginners Questions & Answers awk to match condition and print in columns Post 303044785 by shanul karim on Wednesday 4th of March 2020 01:17:44 AM
Old 03-04-2020
awk to match condition and print in columns
Dear team,


Need support for below request.


Input file


Quote:
safAmfNode=PL-10,safAmfCluster=myAmfCluster
AdminState=UNLOCKED(1)
OperState=ENABLED(1)
safAmfNode=PL-11,safAmfCluster=myAmfCluster
AdminState=UNLOCKED(1)
OperState=ENABLED(1)
safAmfNode=PL-12,safAmfCluster=myAmfCluster
AdminState=UNLOCKED(1)
OperState=ENABLED(1)
safAmfNode=PL-13,safAmfCluster=myAmfCluster
AdminState=LOCKED(1)
OperState=ENABLED(1)

The below code executed successful which check AdminState=UNLOCKED and if not it prints.


Code:
awk -F'=|,| ' 'BEGIN{
  print "Checking PL AND SC AMF STATUS:"
}
/safAmfNode/{
  if (a["AdminState"]!~"UNLOCKED") print a["safAmfNode"],a["AdminState"];
  delete a
}
/safAmfNode/{ FS=",";
  a["safAmfNode"]=$1;
  next
}
/AdminState/{ FS=",";
  a["AdminState"]=$1;
  next
}
/OperState/{
  a["OperState"]=$1;
  next
}

END{
  if (a["AdminState"]!~"UNLOCKED") print a["safAmfNode"],a["AdminState"];
}
' OFS=","   TESTFILE


Output as below


Quote:
Checking PL AND SC AMF STATUS:
,
safAmfNode=PL-13, AdminState=LOCKED(1)

As soon as i print this a["OperState"] array in output. The Output distorted as below.


Code:
awk -F'=|,| ' 'BEGIN{
  print "Checking PL AND SC AMF STATUS:"
}
/safAmfNode/{
  if (a["AdminState"]!~"UNLOCKED") print a["safAmfNode"],a["AdminState"],a["OperState"];
  delete a
}
/safAmfNode/{ FS=",";
  a["safAmfNode"]=$1;
  next
}
/AdminState/{ FS=",";
  a["AdminState"]=$1;
  next
}
/OperState/{ FS=",";
  a["OperState"]=$1;
  next
}

END{
  if (a["AdminState"]!~"UNLOCKED") print a["safAmfNode"],a["AdminState"],a["OperState"];
}
' OFS=","   TESTFILE


Distorted Output as below


Quote:
Checking PL AND SC AMF STATUS:
,,
, OperState=ENABLED(1)nState=LOCKED(1)

instead


Quote:
Checking PL AND SC AMF STATUS:
,
safAmfNode=PL-13, AdminState=LOCKED(1), OperState=ENABLED(1)

Thanks in advance.
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

match columns using awk

Hi All, I need some help in writing a small script using Awk. My input file has following deatils A,B,C,D 8239359,8239359,8388125,8388125 8239359,8239359,8388125,8388125 7165981,7165981,8363138,8363138 8283830,8283830,8382987,8382987 8209964,8209964,8367098,8367098 ... (8 Replies)
Discussion started by: pistachio
8 Replies

2. Shell Programming and Scripting

awk to print lines based on string match on another line and condition

Hi folks, I have a text file that I need to parse, and I cant figure it out. The source is a report breaking down softwares from various companies with some basic info about them (see source snippet below). Ultimately what I want is an excel sheet with only Adobe and Microsoft software name and... (5 Replies)
Discussion started by: rowie718
5 Replies

3. Shell Programming and Scripting

Match and print columns in second file

Hi All, I have to match each row in file 1 with 1st row in file 2 and print the corresponding column from file2. I am trying to use an awk script to do this. For example cat File1 X1 X3 X4 cat File2 ID X1 X2 X3 X4 A 1 6 2 1 B 2 7 3 3 C 3 8 4 1 D 4 9 1 1 (3 Replies)
Discussion started by: newpro
3 Replies

4. Shell Programming and Scripting

match two key columns in two files and print output (awk)

I have two files... file1 and file2. Where columns 1 and 2 of file1 match columns 1 and 2 of file2 I want to create a new file that is all file1 + columns 3 and 4 of file2 :b: Many thanks if you know how to do this.... :b: file1 31-101 106 0 92 31-101 106 29 ... (2 Replies)
Discussion started by: pelhabuan
2 Replies

5. Shell Programming and Scripting

Match two columns from two files and print output

Hello, I have two files which are of the following format File 1 which has two columns Protein_ID Substitution NP_997239 T53R NP_060668 V267M NP_058515 P856A NP_001206 T55M NP_006601 D371Y ... (2 Replies)
Discussion started by: nans
2 Replies

6. UNIX for Advanced & Expert Users

Match and print based on columns

HI, I have 2 different questions in this thread. Consider 2 files as input (input file have different line count ) File 1 1 1 625 56 1 12 657 34 1 9 25 45 1 2 20 54 67 3 25 35 27 4 45 73 36 5 125 56 45 File2 1 1 878 76 1 9 83 67 2 20 73 78 4 47 22 17 3 25 67 99 (4 Replies)
Discussion started by: rossi
4 Replies

7. Shell Programming and Scripting

Match columns and print specific field

Hello, I have data in following format. ... (6 Replies)
Discussion started by: Pushpraj
6 Replies

8. Shell Programming and Scripting

awk if condition match and print all

Hi, I am trying to do something like this ... I use awk to match a pattern, and then print out all col. My code is : awk '{if ($1 ==300) print $1,$2-'$sbin7',$3}' tmp.txt output= 300 2 whereby sbin7=2, The thing is, I want to print all col and row, not just the matched line/row only, but... (10 Replies)
Discussion started by: horsepower
10 Replies

9. Shell Programming and Scripting

awk if condition match and fix print decimal place

Hi All, I have problem in the middle of implementing to users, whereby the complaint is all about the decimal place which is too long. I need two decimal places only, but the outcome from command is always fixed to 6. See the sample : before: Sort Total Site Sort SortName Parts ... (3 Replies)
Discussion started by: horsepower
3 Replies

10. Shell Programming and Scripting

awk to print match or non-match and select fields/patterns for non-matches

In the awk below I am trying to output those lines that Match between file1 and file2, those Missing in file1, and those missing in file2. Using each $1,$2,$4,$5 value as a key to match on, that is if those 4 fields are found in both files the match, but if those 4 fields are not found then missing... (0 Replies)
Discussion started by: cmccabe
0 Replies

LEARN ABOUT SUSE

amf.conf

AMF.CONF(5)							File Formats Manual						       AMF.CONF(5)

NAME

       amf.conf - corosync AMF configuration file

DESCRIPTION

       amf.conf  is the configuration file that determines the behaviour of the AIS Availability Management Framework service, AMF in the corosync
       implementation.

       Entries in this file will for example determine what applications AMF will start and how to supervise them.

       By default AMF opens /etc/ais/amf.conf. The environment variable OPENAIS_AMF_CONFIG_FILE can be set to the pathname of an AMF configuration
       file to override the default behaviour.

       Any line whose first non-white-space character is a '#' is considered a comment line. Empty lines are ignored.

       The file contains object entries of the form:

	      <Object Class> = <Object Name> {
		     <attribute> = <value>
		     ...
	      }

       Object  entries	are  nested,  one  entry  contains another entry. This way relations between objects are built up. For example a component
       object defined inside a Software Unit (SU) object means that the component belongs to the SU. In other words, the SU  is  composed  of  the
       component. See the example configuration file.

       The relation between objects has to comply with the AMF model specified in [5].

       Object  names  shall  use  only printable ASCII characters. Object names shall be unique within its context, i.e. two components within the
       same service unit has to have different names, but can have the same name as another component within another service unit.

       Attribute names are consistent with the naming of the configuration attributes in [5].

       AMF object attributes are either configuration or runtime  attributes.  The  AMF  configuration	file  is  used	to  specify  configuration
       attributes. Some configuration attributes have default values and does not need to be specified. Others are not valid in certain redundancy
       models and so on.

       The type of an attribute value is either a string, a number, a time or an enumeration. Enumeration values are specified	according  to  the
       type definition in the AIS specification. Time values are specified in milliseconds.

       Multivalue attributes are specified using multiple entries with the same attribute name but different values. See the example configuration
       file.

       The (RDN) value of 'safAmfNode' is a logical name for an AMF node. It is mapped to a real physical node	using  the  attribute  'saAmfNode-
       ClmNode'.

       The  value of the attribute 'saAmfNodeClmNode' should be the hostname (without domain name) as given to the host at boot time. This name is
       returned by the shell command 'hostname'.

       Currently, AMF is enabled/disabled by an entry in the corosync.conf file, see [1].  It is default disabled.

       The following list of attributes is currently supported:

       safAmfCluster

       saAmfClusterStartupTimeout

       safAmfNode

       saAmfNodeClmNode 	       Host name, required

       saAmfNodeSuFailOverProb	       Required but not used.

       saAmfNodeSuFailoverMax	       Required but not used.

       safApp

       clccli_path		       A path added to all CLC-CLI scripts

       saAmfSIProtectedbySG	       Required when several SGs are specified

       safSg

       safSi

       saAmfSINumCSIs		       Required but not used.

       safCSType

       saAmfSGRedundancyModel	       Currently only 'nplusm' is supported, required.

       saAmfSGNumPrefActiveSUs

       saAmfSGNumPrefStandbySUs

       saAmfSGMaxActiveSIsperSUs

       saAmfSGMaxStandbySIsperSUs

       saAmfSGCompRestartProb	       Required but not used.

       saAmfSGCompRestartMax

       saAmfSGSuRestartProb	       Required but not used.

       saAmfSGAutoAdjustProb	       Required but not used.

       saAmfSGSuRestartMax

       safSu

       saAmfSUNumComponents	       Required but not used.

       saAmfSUIsExternal	       Required but not used.

       saAmfSUFailover		       Required but not used.

       saAmfSUHostedByNode	       Required. Set to AMF node name. Note: this is a deviation from the specification.

       safComp

       saAmfCompCsTypes 	       Multivalue

       saAmfCompCategory

       saAmfCompCapability	       Required but not used.

       saAmfCompNumMaxActiveCsi        Required but not used.

       saAmfCompNumMaxStandbyCsi       Required but not used.

       saAmfCompCmdEnv		       Multivalue

       saAmfCompDefaultClcCliTimeout   Required but not used.

       saAmfCompDefaultCallbackTimeOut Required but not used.

       saAmfCompInstantiateCmdArgv

       saAmfCompInstantiateCmd

       saAmfCompTerminateCmdArgv       Required but not used.

       saAmfCompTerminateCmd	       Required but not used.

       saAmfCompCleanupCmdArgv

       saAmfCompCleanupCmd

       saAmfCompRecoveryOnError        Required but not used.

       safHealthcheckKey

       saAmfHealthcheckPeriod

       saAmfHealthcheckMaxDuration

       safCsi

       saAmfSIPrefActiveAssignments

       saAmfSIPrefStandbyAssignments

       saAmfCSTypeName

       safCSIAttr		       Multivalue

AUTHOR

       Hans.Feldt at ericsson.com

EXAMPLE

       For an AMF configuration file example, see the amf.conf file under the corosync conf directory.

FILES

       /etc/ais/amf.conf

       /etc/ais/corosync.conf

SEE ALSO

       [1] corosync_conf (5)

       [2] corosync_overview (8)

       [3] README.amf

       [4] www.saforum.org - SAI-XMI-A.01.01.xml.xip

       [5] www.saforum.org - SAI-Overview.B.02.01.pdf

       [6] www.saforum.org - SAI-AIS-AMF-B.02.01.pdf

corosync Man Page						    2006-08-29							       AMF.CONF(5)
All times are GMT -4. The time now is 07:38 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy