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 DEBIAN

grid-cert-diagnostics

GRID-CERT-DIAGNOST(1)						  Globus Commands					     GRID-CERT-DIAGNOST(1)

NAME

       grid-cert-diagnostics - Print diagnostic information about certificates and keys

SYNOPSIS

       grid-cert-diagnostics [-h] | [-help]  [-p] [-n] [-c CERTIFICATE]

DESCRIPTION

       The grid-cert-diagnostics program displays information about the current user's security environment, including information about
       security-related environment variables, security directory search path, personal key and certificates, and trusted certificates. It is
       intended to provide information to help diagnose problems using GSIC.

       By default, grid-cert-diagnostics prints out information regarding the environment and trusted certificate directory. If the -p
       command-line option is used, then additional information about the current user's default certificate and key will be printed.

       The full set of command-line options to grid-cert-diagnostics consists of:

       -h, -help
	   Display a help message and exit.

       -p
	   Display information about the personal certificate and key that is the current user's default credential.

       -n
	   Check time synchronization with the ntpdate command.

       -c CERTIFICATE, -c -
	   Check the validity of the certificate in the file named by CERTIFICATE or standard input if the parameter to -c is -.

EXAMPLES

       In this example, we see the default mode of checking the default security environment for the system, without processing the user's key and
       certificate. Note the user receives a warning about a cog.properties and about an expired CA certificate.

	   % grid-cert-diagnostics

	   Checking Environment Variables
	   ==============================
	   Checking if X509_CERT_DIR is set... no
	   Checking if X509_USER_CERT is set... no
	   Checking if X509_USER_KEY is set... no
	   Checking if X509_USER_PROXY is set... no

	   Checking Security Directories
	   =======================
	   Determining trusted cert path... /etc/grid-security/certificates
	   Checking for cog.properties... found
	       WARNING: If the cog.properties file contains security properties,
			Java apps will ignore the security paths described in the GSI
			documentation

	   Checking trusted certificates...
	   ================================
	   Getting trusted certificate list...
	   Checking CA file /etc/grid-security/certificates/1c4f4c48.0... ok
	   Verifying certificate chain for "/etc/grid-security/certificates/1c3f2ca8.0"... ok
	   Checking CA file /etc/grid-security/certificates/9d8788eb.0... ok
	   Verifying certificate chain for "/etc/grid-security/certificates/9d8753eb.0"... failed
	       globus_credential: Error verifying credential: Failed to verify credential
	       globus_gsi_callback_module: Could not verify credential
	       globus_gsi_callback_module: The certificate has expired:
	       Credential with subject: /DC=org/DC=example/OU=grid/CN=CA has expired.

       In this example, we show a user with a mismatched private key and certificate:

	   % grid-cert-diagnostics -p

	   Checking Environment Variables
	   ==============================
	   Checking if X509_CERT_DIR is set... no
	   Checking if X509_USER_CERT is set... no
	   Checking if X509_USER_KEY is set... no
	   Checking if X509_USER_PROXY is set... no

	   Checking Security Directories
	   =======================
	   Determining trusted cert path... /etc/grid-security/certificates
	   Checking for cog.properties... not found

	   Checking Default Credentials
	   ==============================
	   Determining certificate and key file names... ok
	   Certificate Path: "/home/juser/.globus/usercert.pem"
	   Key Path: "/home/juser/.globus/userkey.pem"
	   Reading certificate... ok
	   Reading private key...
	   ok
	   Checking Certificate Subject...
	   "/O=Grid/OU=Example/OU=User/CN=Joe User"
	   Checking cert... ok
	   Checking key... ok
	   Checking that certificate contains an RSA key... ok
	   Checking that private key is an RSA key... ok
	   Checking that public and private keys have the same modulus... failed
	   Private key modulus: D294849E37F048C3B5ACEEF2CCDF97D88B679C361E29D5CB5
	   219C3E948F3E530CFC609489759E1D751F0ACFF0515A614276A0F4C11A57D92D7165B8
	   FA64E3140155DE448D45C182F4657DA13EDA288423F5B9D169DFF3822EFD81EB2E6403
	   CE3CB4CCF96B65284D92592BB1673A18354DA241B9AFD7F494E54F63A93E15DCAE2
	   Public key modulus : C002C7B329B13BFA87BAF214EACE3DC3D490165ACEB791790
	   600708C544175D9193C9BAC5AED03B7CB49BB6AE6D29B7E635FAC751E9A6D1CEA98022
	   6F1B63002902D6623A319E4682E7BFB0968DCE962CF218AAD95FAAD6A0BA5C42AA9AAF
	   7FDD32B37C6E2B2FF0E311310AA55FFB9EAFDF5B995C7D9EEAD8D5D81F3531E0AE5
	   Certificate and and private key don't match

AUTHOR

       University of Chicago

Globus Toolkit 5.0.2						    04/25/2011						     GRID-CERT-DIAGNOST(1)
All times are GMT -4. The time now is 09:52 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy