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
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
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
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
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
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
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
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
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
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
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
LEARN ABOUT OPENSOLARIS
scha_resourcegroup_get
scha_resourcegroup_get(1HA) Sun Cluster Commands scha_resourcegroup_get(1HA)
NAME
scha_resourcegroup_get - access resource group information
SYNOPSIS
scha_resourcegroup_get -O optag -G group [args]
DESCRIPTION
The scha_resourcegroup_get command accesses information about a resource group that is under the control of the Resource Group Manager
(RGM) cluster facility.
This command is intended to be used in shell script implementations of the callback methods for resource types. These resource types repre-
sent services that are controlled by the cluster's RGM. This command provides the same information as the scha_resourcegroup_get(3HA) C
function.
Information is generated by the command to standard output (stdout) in formatted strings as described in scha_cmds(1HA). The output is a
string or several strings on separate lines. The output can be stored in shell variables and parsed using shell facilities or awk(1) for
further use by the script.
You need solaris.cluster.resource.read role-based access control (RBAC) authorization to use this command. See rbac(5).
You must also be able to assume a role to which the Sun Cluster Commands rights profile has been assigned to use this command. Authorized
users can issue privileged Sun Cluster commands on the command line from the pfsh(1), pfcsh(1), or pfksh(1) profile shell. A profile shell
is a special kind of shell that enables you to access privileged Sun Cluster commands that are assigned to the Sun Cluster Commands rights
profile. A profile shell is launched when you run su(1M) to assume a role. You can also use pfexec(1) to issue privileged Sun Cluster com-
mands.
OPTIONS
The following options are supported:
-G group Name of the resource group.
-O optag Specifies the information that is to be accessed. Depending on the optag that you specify, you might need to include an addi-
tional operand to indicate the node or zone for which information is to be retrieved.
Note -
optag values, such as DESIRED_PRIMARIES and FAILBACK, are not case sensitive. You can use any combination of uppercase and
lowercase letters when you specify optag options.
The following optag values retrieve the corresponding resource group properties. The value of the named property of the
resource group is generated. The RG_STATE property refers to the value on the particular node or zone where the command is
executed.
AUTO_START_ON_NEW_CLUSTER
DESIRED_PRIMARIES
FAILBACK
GLOBAL_RESOURCES_USED
IMPLICIT_NETWORK_DEPENDENCIES
MAXIMUM_PRIMARIES
NODELIST
PATHPREFIX
PINGPONG_INTERVAL
RESOURCE_LIST
RG_AFFINITIES
RG_DEPENDENCIES
RG_DESCRIPTION
RG_IS_FROZEN
RG_MODE
RG_PROJECT_NAME
RG_SLM_TYPE
RG_SLM_PSET_TYPE
RG_SLM_CPU
RG_SLM_CPU_MIN
RG_STATE
RG_STATE_NODE
RG_SYSTEM
SUSPEND_AUTOMATIC_RECOVERY
Note -
RG_STATE_NODE requires an unflagged argument that specifies a node or zone. This optag value generates the value of the resource group's
RG_STATE property for the specified node or zone. If the unflagged argument specifies a non-global zone, the format is nodename:zonename.
EXAMPLES
Example 1 A Sample Script Using scha_resourcegroup_get
The following script is passed a -G argument, which provides the required resource group name. Next, the scha_resourcegroup_get command is
used to get the list of resources in the resource group.
#!/bin/sh
while getopts G: opt
do
case $opt in
G) group="$OPTARG";;
esac
done
resource_list=`scha_resourcegroup_get -O Resource_list -G $group`
for resource in $resource_list
do
printf "Group: %s contains resource: %s0 "$group" "$resource"
done
EXIT STATUS
The following exit status codes are returned:
0 The command completed successfully.
nonzero An error occurred.
Failure error codes are described 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), scha_cmds(1HA), scha_calls(3HA), scha_resourcegroup_get(3HA), attributes(5), rg_properties(5), rbac(5)
Sun Cluster 3.2 6 Sep 2006 scha_resourcegroup_get(1HA)