how to exclude the header in shell script using awk Post: 302334563

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...

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} ...

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. 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...

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...

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. 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...

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...

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

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...

LEARN ABOUT OPENSOLARIS

scha_resourcetype_get

scha_resourcetype_get(1HA)				       Sun Cluster Commands					scha_resourcetype_get(1HA)

NAME

       scha_resourcetype_get - access resource type information

SYNOPSIS

       scha_resourcetype_get  -O optag -T type

DESCRIPTION

       The scha_resourcetype_get command accesses information about a resource type that is registered with the Resource Group Manager (RGM).

       Use  this command in shell script implementations of the callback methods for resource types that represent services that are controlled by
       the RGM. This command provides the same information as the scha_resourcetype_get(3HA) C function.

       Information is output by this command to the standard output (stdout) in formatted strings, as described in the	scha_cmds(1HA)	man  page.
       Output  is  a  string or several strings that are output on separate lines. You can store the output in shell variables. You can also parse
       the output by using the awk(1) command or other shell commands for further use by the script.

       You need solaris.cluster.resource.read RBAC authorization to use this command. See the rbac(5) man page.

       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 commands.

OPTIONS

       The following options are supported:

       -O optag     Indicates the information to be accessed.

		    Note -

		      optag  options, such as API_VERSION and BOOT, 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 type properties.  The  value  of  the  named  property  of  the
		    resource's type is output.

		      API_VERSION
		      BOOT
		      FAILOVER
		      FINI
		      INIT
		      INIT_NODES
		      INSTALLED_NODES
		      IS_LOGICAL_HOSTNAME
		      IS_SHARED_ADDRESS
		      MONITOR_CHECK
		      MONITOR_START
		      MONITOR_STOP
		      PKGLIST
		      POSTNET_STOP
		      PRENET_START
		      RESOURCE_LIST
		      RT_BASEDIR
		      RT_DESCRIPTION
		      RT_SYSTEM
		      RT_VERSION
		      SINGLE_INSTANCE
		      START
		      STOP
		      UPDATE
		      VALIDATE

       -T type	    Is the name of a resource type that is registered for use by the RGM cluster facility.

EXIT STATUS

       The following exit values 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_resourcetype_get(3HA), attributes(5), rt_properties(5)

Sun Cluster 3.2 						    31 May 2006 					scha_resourcetype_get(1HA)