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
scha_cmds(1HA)						       Sun Cluster Commands						    scha_cmds(1HA)

NAME
scha_cmds - command standard output for scha_cluster_get, scha_control, scha_resource_get, scha_resourcegroup_get, scha_resourcetype_get, scha_resource_setstatus SYNOPSIS
scha_command -O optag... DESCRIPTION
The Sun Cluster scha_cluster_get(1HA), scha_control(1HA), scha_resource_get(1HA), scha_resourcegroup_get(1HA), scha_resourcetype_get(1HA), and scha_resource_setstatus(1HA) commands are command-line implementations of the callback methods for resource types. See rt_call- backs(1HA). Resource types represent services that are controlled by the cluster's Resource Group Manager (RGM) facility. These commands provide a com- mand-line interface to the functionality of the scha_calls(3HA) C functions. The get commands access cluster configuration information. All of these commands have the same general interface. These commands all take an -O optag operand. This operand indicates the information to be accessed. These commands all send the results to the standard output (stdout) as formatted strings. Additional arguments might be needed depending on the command and the value of optag. For information about the format of different optag results, see the "Results Format" section. Note - optag options, for all scha commands, are not case sensitive. You can use any combination of uppercase and lowercase letters when you specify optag options. The scha_control(1HA) command also takes an -O optag option that indicates a control operation, but does not produce output to standard output. The scha_resource_setstatus(1HA) command sets the STATUS and STATUS_MSG properties of a resource that is managed by the RGM. Result Formats The format of strings that are output to the standard output by the commands depends on the type of the result that is indicated by the optag that you include with the -O option. Formats for each type are specified in the following table. Format notation is described in for- mats(5). Result Type Format on Standard Output boolean TRUE or FALSE enum %s , the string name of an enum value. extension %s , the type attribute of the exten- sion property, which is one of the fol- lowing values: STRING, INT, BOOLEAN, ENUM, or STRINGARRAY.Following the type information, the property value is out- put according to the formats for each type as follows: STRING as string, INT as int, BOOLEAN as boolean, ENUM as enum, STRINGARRAY as string_array. int %d status %s %s , the first string is the sta- tus, which is one of the following enum values: DEGRADED, FAULTED, OFFLINE, ONLINE, or UNKNOWN.The second string is the status message. string %s string_array Each element in the array is output in the format %s . An asterisk, indicat- ing all nodes, zones, or resources, can be returned for the GLOBAL_RESOURCES_USED and INSTALLED_NODES properties. unsigned_int %u unsigned_int_array Each element in the array is output in the format %u optag Result Types The following table specifies the valid optag values for different commands as well as the type of the result that is output according to the formats specified in the previous table. optag Values for scha_cluster_get(1HA) Result Type ALL_NODEIDS unsigned_int_array ALL_NODENAMES string_array ALL_NONGLOBAL_ZONES string ALL_NONGLOBAL_ZONES_NODEID string ALL_PRIVATELINK_HOSTNAMES string_array ALL_RESOURCEGROUPS string_array ALL_RESOURCETYPES string_array ALL_ZONES string ALL_ZONES_NODEID string CLUSTERNAME string NODEID_LOCAL unsigned_int NODEID_NODENAME unsigned_int NODENAME_LOCAL string NODENAME_NODEID string NODESTATE_LOCAL enum (UP, DOWN) NODESTATE_NODE enum (UP, DOWN) PRIVATELINK_HOSTNAME_LOCAL string PRIVATELINK_HOSTNAME_NODE string SYSLOG_FACILITY int ZONE_LOCAL string optag Values for scha_control(1HA) -------------------------------------------------------- CHANGE_STATE_OFFLINE CHANGE_STATE_ONLINE CHECK_GIVEOVER CHECK_RESTART GIVEOVER IGNORE_FAILED_START RESOURCE_DISABLE RESOURCE_IS_RESTARTED RESOURCE_RESTART RESTART optag Values for scha_resource_get(1HA) Result Type AFFINITY_TIMEOUT int ALL_EXTENSIONS string_array BOOT_TIMEOUT int CHEAP_PROBE_INTERVAL int CHEAP_PROBE_INTERVAL int EXTENSION extension EXTENSION_NODE extension FAILOVER_MODE enum (NONE, HARD, SOFT, RESTART_ONLY, LOG_ONLY ) FINI_TIMEOUT int GROUP string INIT_TIMEOUT int LOAD_BALANCING_POLICY string LOAD_BALANCING_WEIGHTS string_array LOGICAL_HOSTNAMES_USED string_array MONITORED_SWITCH enum (DISABLED, ENABLED) MONITORED_SWITCH_NODE enum (DISABLED, ENABLED) MONITOR_CHECK_TIMEOUT int MONITOR_START_TIMEOUT int MONITOR_STOP_TIMEOUT int NETWORK_RESOURCES_USED string_array NUM_RESOURCE_RESTARTS int NUM_RESOURCE_RESTARTS_ZONE int NUM_RG_RESTARTS int NUM_RG_RESTARTS int NUM_RG_RESTARTS_ZONE int ON_OFF_SWITCH enum (DISABLED, ENABLED) ON_OFF_SWITCH_NODE enum (DISABLED, ENABLED) PORT_LIST string_array POSTNET_STOP_TIMEOUT int PRENET_START_TIMEOUT int R_DESCRIPTION string RESOURCE_DEPENDENCIES string_array RESOURCE_DEPENDENCIES_OFFLINE_RESTART string_array RESOURCE_DEPENDENCIES_RESTART string_array RESOURCE_DEPENDENCIES_WEAK string_array RESOURCE_PROJECT_NAME string RESOURCE_STATE enum (ONLINE, OFFLINE, START_FAILED, STOP_FAILED, MONITOR_FAILED, ONLINE_NOT_MONITORED, STARTING, STOPPING) RESOURCE_STATE_NODE enum (see RESOURCE_STATE for values) RETRY_COUNT int RETRY_INTERVAL int SCALABLE boolean START_TIMEOUT int STATUS status STATUS_NODE status STOP_TIMEOUT int THOROUGH_PROBE_INTERVAL int TYPE string TYPE_VERSION string UDP_AFFINITY boolean UPDATE_TIMEOUT int VALIDATE_TIMEOUT int WEAK_AFFINITY boolean optag Values for Result Type scha_resource_get(1HA) and scha_resource- type_get(1HA) API_VERSION int BOOT string FAILOVER boolean FINI string GLOBAL_ZONE boolean INIT string INIT_NODES enum (RG_PRIMARIES, RT_INSTALLED_NODES ) INSTALLED_NODES string_array. An asterisk (*) is returned to indicate all nodes. IS_LOGICAL_HOSTNAME boolean IS_SHARED_ADDRESS boolean MONITOR_CHECK string MONITOR_START string MONITOR_STOP string PER_NODE boolean PKGLIST string_array POSTNET_STOP string PRENET_START string PROXY boolean RT_BASEDIR string RT_DESCRIPTION string RT_SYSTEM boolean RT_VERSION string SINGLE_INSTANCE boolean START string STOP string UPDATE string VALIDATE string optag Values for Result Type scha_resourcegroup_get(1HA) AUTO_START_ON_NEW_CLUSTER boolean DESIRED_PRIMARIES int FAILBACK boolean GLOBAL_RESOURCES_USED string_array (an asterisk (*) is returned to indicate all resources) IMPLICIT_NETWORK_DEPENDENCIES boolean MAXIMUM_PRIMARIES int NODELIST string_array PATHPREFIX string PINGPONG_INTERVAL int RESOURCE_LIST string_array RG_AFFINITIES string_array RG_DEPENDENCIES string_array RG_DESCRIPTION string RG_IS_FROZEN boolean RG_MODE enum (FAILOVER, SCALABLE) RG_PROJECT_NAME string RG_SLM_CPU decimal RG_SLM_CPU_MIN decimal RG_SLM_PSET_TYPE enum (DEFAULT, DEDI- CATED_STRONG, DEDICATED_WEAK) RG_SLM_TYPE enum (AUTOMATED, MANUAL) RG_STATE enum (UNMANAGED, ONLINE, OFF- LINE, PENDING_ONLINE, PEND- ING_OFFLINE, ERROR_STOP_FAILED, ONLINE_FAULTED, PEND- ING_ONLINE_BLOCKED) RG_STATE_NODE enum (see RG_STATE for values) RG_SYSTEM boolean SUSPEND_AUTOMATIC_RECOVERY boolean EXIT STATUS
One set of exit status codes is used for all scha commands. The exit status codes are the numeric values of the scha_err_t return codes of the corresponding C functions as described in scha_calls(3HA). ATTRIBUTES
See attributes(5) for descriptions of the following attributes: +-----------------------------+-----------------------------+ | ATTRIBUTE TYPE | ATTRIBUTE VALUE | +-----------------------------+-----------------------------+ |Availability |SUNWscdev | +-----------------------------+-----------------------------+ |Interface Stability |Stable | +-----------------------------+-----------------------------+ SEE ALSO
awk(1), rt_callbacks(1HA), scha_cluster_get(1HA), scha_control(1HA), scha_resource_get(1HA), scha_resourcegroup_get(1HA), scha_resource- type_get(1HA), scha_resource_setstatus(1HA), scha_calls(3HA), attributes(5), formats(5), r_properties(5), rg_properties(5), rt_proper- ties(5) Sun Cluster 3.2 13 Jul 2006 scha_cmds(1HA)
All times are GMT -4. The time now is 01:43 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy