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