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 303044787 by RudiC on Wednesday 4th of March 2020 03:08:00 AM
Old 03-04-2020
I'm glad I'm not the only one having difficulties with the OP's specification, even though this one - being the third on the same topic - has way more details than the former ones.


The problem you encounter likely has to do with DOS line terminators (<CR> = ^M = \r = 0x0D) in the input file. This is what I get from your code with a "clean" input:
Code:
Checking PL AND SC AMF STATUS:
,,
safAmfNode=PL-13,AdminState=LOCKED(1),OperState=ENABLED(1)

, as opposed to what a "contaminated" input yields:
Code:
Checking PL AND SC AMF STATUS:
,,
,OperState=ENABLED(1)nState=LOCKED(1)

Let me add that your approach - although working - has quite some potential for improving. Pls check this aprroach:
Code:
awk -F, '
BEGIN                   {print "Checking PL AND SC AMF STATUS:"
                        }

                        {gsub ("\r", "")
                        }

/^safAmfNode/           {TMP = $1
                        }
/^AdminState/ &&
!/UNLOCKED/             {getline OP
                         print TMP, $0, OP
                        }
' OFS="," file
Checking PL AND SC AMF STATUS:
safAmfNode=PL-13,AdminState=LOCKED(1),OperState=ENABLED(1)

Last edited by RudiC; 03-04-2020 at 04:13 AM..
 

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 CENTOS

gnutls-cli-debug

gnutls-cli-debug(1)						   User Commands					       gnutls-cli-debug(1)

NAME

       gnutls-cli-debug - GnuTLS debug client

SYNOPSIS

       gnutls-cli-debug [-flag [value]]... [--opt-name[[=| ]value]]...

       Operands and options may be intermixed.	They will be reordered.

DESCRIPTION

       TLS  debug  client.  It	sets  up  multiple TLS connections to a server and queries its capabilities. It was created to assist in debugging
       GnuTLS, but it might be useful to extract a TLS server's capabilities.  It connects to a TLS server, performs tests and print the  server's
       capabilities.  If  called  with	the  `-v' parameter more checks will be performed.  Can be used to check for servers with special needs or
       bugs.

OPTIONS

       -d number, --debug=number
	      Enable debugging..  This option takes an integer number as its argument.	The value of number is constrained to being:
		  in the range	0 through 9999

	      Specifies the debug level.

       -V, --verbose
	      More verbose output.  This option may appear an unlimited number of times.

       -p number, --port=number
	      The port to connect to.  This option takes an integer number as its argument.  The value of number is constrained to being:
		  in the range	0 through 65536

       -h, --help
	      Display usage information and exit.

       -!, --more-help
	      Pass the extended usage information through a pager.

       -v [{v|c|n}], --version[={v|c|n}]
	      Output version of program and exit.  The default mode is `v', a simple version.  The `c' mode will print copyright information and
	      `n' will print the full copyright notice.

EXAMPLES

	   $ ../src/gnutls-cli-debug localhost
	   Resolving 'localhost'...
	   Connecting to '127.0.0.1:443'...
	   Checking for SSL 3.0 support... yes
	   Checking whether %COMPAT is required... no
	   Checking for TLS 1.0 support... yes
	   Checking for TLS 1.1 support... no
	   Checking fallback from TLS 1.1 to... TLS 1.0
	   Checking for TLS 1.2 support... no
	   Checking whether we need to disable TLS 1.0... N/A
	   Checking for Safe renegotiation support... yes
	   Checking for Safe renegotiation support (SCSV)... yes
	   Checking for HTTPS server name... not checked
	   Checking for version rollback bug in RSA PMS... no
	   Checking for version rollback bug in Client Hello... no
	   Checking whether the server ignores the RSA PMS version... no
	   Checking whether the server can accept Hello Extensions... yes
	   Checking whether the server can accept small records (512 bytes)... yes
	   Checking whether the server can accept cipher suites not in SSL 3.0 spec... yes
	   Checking whether the server can accept a bogus TLS record version in the client hello... yes
	   Checking for certificate information... N/A
	   Checking for trusted CAs... N/A
	   Checking whether the server understands TLS closure alerts... partially
	   Checking whether the server supports session resumption... yes
	   Checking for export-grade ciphersuite support... no
	   Checking RSA-export ciphersuite info... N/A
	   Checking for anonymous authentication support... no
	   Checking anonymous Diffie-Hellman group info... N/A
	   Checking for ephemeral Diffie-Hellman support... no
	   Checking ephemeral Diffie-Hellman group info... N/A
	   Checking for ephemeral EC Diffie-Hellman support... yes
	   Checking ephemeral EC Diffie-Hellman group info...
	    Curve SECP256R1
	   Checking for AES-GCM cipher support... no
	   Checking for AES-CBC cipher support... yes
	   Checking for CAMELLIA cipher support... no
	   Checking for 3DES-CBC cipher support... yes
	   Checking for ARCFOUR 128 cipher support... yes
	   Checking for ARCFOUR 40 cipher support... no
	   Checking for MD5 MAC support... yes
	   Checking for SHA1 MAC support... yes
	   Checking for SHA256 MAC support... no
	   Checking for ZLIB compression support... no
	   Checking for max record size... no
	   Checking for OpenPGP authentication support... no

EXIT STATUS

       One of the following exit values will be returned:

       0 (EXIT_SUCCESS)
	      Successful program execution.

       1 (EXIT_FAILURE)
	      The operation failed or the command syntax was not valid.

       70 (EX_SOFTWARE)
	      libopts had an internal operational error.  Please report it to autogen-users@lists.sourceforge.net.  Thank you.

SEE ALSO

       gnutls-cli(1), gnutls-serv(1)

AUTHORS

       Nikos Mavrogiannopoulos, Simon Josefsson and others; see /usr/share/doc/gnutls-bin/AUTHORS for a complete list.

COPYRIGHT

       Copyright (C) 2000-2012 Free Software Foundation all rights reserved.  This program is released under the terms of the GNU General Public
       License, version 3 or later.

BUGS

       Please send bug reports to: bugs@gnutls.org

NOTES

       This manual page was AutoGen-erated from the gnutls-cli-debug option definitions.

3.1.18								    20 Dec 2013 					       gnutls-cli-debug(1)
All times are GMT -4. The time now is 11:32 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy