Sponsored Content
Top Forums Shell Programming and Scripting how to exclude the header in shell script using awk Post 302334506 by gates1580 on Wednesday 15th of July 2009 06:34:17 PM
Old 07-15-2009
how to exclude the header in shell script using awk

Hello Everyone
In my shell script, I am retrieving the cluster ID and node number of an LPAR using the following command -

lsclcfg -l

This command's output looks as follows -

CLUSTER_NAME CLUSTER_ID NODE_NR
sch1h004 6104567 3


I want to store only the values of cluster_id and node_nr in the 2nd row into two different variables in my shell script. I don't need the first row i.e. the header.

I was playing around with awk command to see if I can accomplish this but to no avail.
Any thoughts/ideas as to how to accomplish this would be appreciated.
Thanks
gates1580
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

awk script to update header record

I am using HP UX and think this may be done with awk but bot sure. I have a file with a several header records and undeneath many detail records I need to put in the header record the number of detail records above this header record and number of detail records below this header record Header... (5 Replies)
Discussion started by: klut
5 Replies

2. UNIX for Dummies Questions & Answers

Executing a tar command with the --exclude option in a Debian shell script.

Hi All, I am trying to execute the following tar command with two --exclude options to suppress extract of the two directories specified. Do I need to single quote the directory paths ?? Many thanks for your help. The relevant code excerpt from the script is: cd /var/www/${SITE} ... (7 Replies)
Discussion started by: daveu7
7 Replies

3. UNIX for Dummies Questions & Answers

append column and row header to a file in awk script.

Hi! Is there a way to append column and row header to a file in awk script. For example if I have Jane F 39 manager Carlos M 40 system administrator Sam F 20 programmer and I want it to be # name gend age occup 1 Jane F 39 manager 2 Carlos M ... (4 Replies)
Discussion started by: FUTURE_EINSTEIN
4 Replies

4. Shell Programming and Scripting

Exclude the header row in the file to validate

Hi All, File contains header row.. we need to exclude the header row...no need to validate the first row in the file. Data in the file should take valid data(two columns)..we need to exclude the more than two columns in the file except the first line. email|firstname a|123|100 b|345... (4 Replies)
Discussion started by: bmk
4 Replies

5. Shell Programming and Scripting

Awk/sed script for transposing any number of rows with header row

Greetings! I have been trying to find out a way to take a CSV file with a large number of rows, and a very large number of columns (in the thousands) and convert the rows to a single column of data, where the first row is a header representing the attribute name and the subsequent series of... (3 Replies)
Discussion started by: tntelle
3 Replies

6. Shell Programming and Scripting

Exclude the header row while splitting the file

Hi All, i have script like ... "TYPE_ID" "ID" "LIST_ID" "18" "52010" "1059" "18" "52010" "1059" "18" "52010" "1059" "18" "52010" "1059" i am using the below code it's not taking the header row. awk -F"\t" -v file=test1.txt -v file1=test2.txt ' { if(... (7 Replies)
Discussion started by: bmk
7 Replies

7. Shell Programming and Scripting

Unable to pass shell script variable to awk command in same shell script

I have a shell script (.sh) and I want to pass a parameter value to the awk command but I am getting exception, please assist. diff=$1$2.diff id=$2 new=new_$diff echo "My id is $1" echo "I want to sync for user account $id" ##awk command I am using is as below cat $diff | awk... (2 Replies)
Discussion started by: Ashunayak
2 Replies

8. Shell Programming and Scripting

Displaying Column header in shell script

Hi, I need to display specific columns using select statement and spooled to a file and sending it as e-mail. But i am not seeing column header in my output even i use SET HEADING ON.//PREDEFINED LOGIN DETAILS ${ORACLE_HOME}/bin/sqlplus -s ${DB_LOGIN}/${DB_PASSWD} <<EOF SET FEEDBACK OFF SET... (1 Reply)
Discussion started by: pvelmuru
1 Replies

9. Shell Programming and Scripting

Exclude First Line when awk

Hi there, Where do I add the !NR==1 into the awk statement such that it ignores the first line . awk '/1.2 Install/ {P=0} /1.1 Apply/ {P=1} P {print FILENAME, $0} ' solarisappsummary.txt solarisdbsummary.txt solaris_websummary.txt (12 Replies)
Discussion started by: alvinoo
12 Replies

10. UNIX for Beginners Questions & Answers

awk script to extract a column, replace one of the header and replace year(from ddmmyy to yyyy)

I have a csv which has lot of columns . I was looking for an awk script which would extract a column twice. for the first occurance the header and data needs to be intact but for the second occurance i want to replace the header name since it a duplicate and extract year value which is in ddmmyy... (10 Replies)
Discussion started by: Kunalcurious
10 Replies
scha_cluster_get(1HA)					       Sun Cluster Commands					     scha_cluster_get(1HA)

NAME
scha_cluster_get - access cluster information SYNOPSIS
scha_cluster_get -O optag [args] DESCRIPTION
The scha_cluster_get command accesses and generates information about a cluster. You can access information about the cluster, nodes, zones, host names, resource groups, resource types, and states. The command is intended for use in shell script implementations of callback methods for resource types. These callback methods for resource types represent services that are controlled by the cluster's Resource Group Manager (RGM). This command provides the same information as the scha_resource_get() function. This command sends output to the standard output (stdout) in formatted strings on separate lines, as described in the scha_cmds(1HA) man page. You can store the output in shell variables. You can also parse the output with shell commands such as the awk command. OPTIONS
The following options are supported: -O optag The optag argument indicates the information to be accessed. Depending on the optag, an additional argument may be needed to indicate the cluster node or zone for which information is to be retrieved. Note - optag options, such as NODENAME_LOCAL and NODENAME_NODEID, are not case sensitive. You can use any combination of uppercase and lowercase letters when you specify optag options. The following optag values are supported: ALL_NODEIDS Generates on successive lines the numeric node identifiers of all nodes in the cluster. ALL_NODENAMES Generates on successive lines the names of all nodes in the cluster. ALL_NONGLOBAL_ZONES Generates on successive lines the nodename:zonename string of all the non-global zones on all nodes in the cluster. ALL_NONGLOBAL_ZONES_NODEID Generates on successive lines the nodename:zonename string of all non-global zones on the cluster node whose numeric node identifier is given as the argument. ALL_PRIVATELINK_HOSTNAMES Generates on successive lines the host names by which all cluster nodes are addressed on the cluster interconnect. ALL_RESOURCEGROUPS Generates on successive lines the names of all the resource groups that are being managed in the cluster. ALL_RESOURCETYPES Generates on successive lines the names of all the resource types that are registered in the cluster. ALL_ZONES Generates on successive lines the nodename:zonename string of all zones, including the global zone, on all nodes in the cluster. ALL_ZONES_NODEID Generates on successive lines the nodename:zonename string of all zones, including the global zone, on the cluster node whose numeric node identifier is given as the argument. CLUSTERNAME Generates the name of the cluster. NODEID_LOCAL Generates the numeric node identifier for the node where the command is executed. NODEID_NODENAME Generates the numeric node identifier of the node indicated by the name. Requires an additional unflagged argument that is the name of a cluster node. NODENAME_LOCAL Generates the name of the cluster node where the command is executed. NODENAME_NODEID Generates the name of the cluster node indicated by the numeric identifier. Requires an additional unflagged argu- ment that is a numeric cluster node identifier. NODESTATE_LOCAL Generates UP or DOWN depending on the state of the node where the command is executed. NODESTATE_NODE Generates UP or DOWN depending on the state of the named node. Requires an additional unflagged argument that is the name of a cluster node. PRIVATELINK_HOSTNAME_LOCAL Generates the host name by which the node on which the command is run is addressed over the cluster interconnect. PRIVATELINK_HOSTNAME_NODE Generates the host name by which the named node is addressed on the cluster interconnect. Requires an additional unflagged argument that is the name of a cluster node. SYSLOG_FACILITY Generates the number of the syslog(3C) facility that the RGM uses for log messages. The value is 24, which corre- sponds to the daemon facility. You can use this value as the facility level in the logger(1) command to log mes- sages in the cluster log. ZONE_LOCAL Generates the name of the zone from which the command is issued. The format of the zone name that is returned is nodename:zonename. EXAMPLES
Example 1 Using the scha_cluster Command in a Shell Script The following shell script uses the scha_cluster command to print whether each cluster node is up or down: #!/bin/sh nodenames=`scha_cluster_get -O All_Nodenames` for node in $nodenames do state=`scha_cluster_get -O NodeState_Node $node` printf "State of node: %sexit: %dvalue: %s0 "$node" $? "$state" done EXIT STATUS
The following exit status codes are returned: 0 Successful completion. nonzero An error occurred. Error codes are 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), logger(1), sh(1), scha_cmds(1HA), syslog(3C), scha_calls(3HA), scha_cluster_get(3HA), attributes(5) Sun Cluster 3.2 6 Sep 2006 scha_cluster_get(1HA)
All times are GMT -4. The time now is 02:04 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy