Sponsored Content
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

Featured Tech Videos

All times are GMT -4. The time now is 07:56 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy