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

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 LINUX

motd.tail

MOTD.TAIL(5)						   Debian Administrator's Manual					      MOTD.TAIL(5)

NAME

       motd.tail - Template for building the system message of the day

DESCRIPTION

       On Debian systems, the system message of the day is rebuilt at each startup, in order to display an accurate information. /etc/motd.tail is
       the file to edit permanent changes to the message of the day.

OVERVIEW

       The initiation script /etc/init.d/bootmisc.sh prepends a line containing information about the system  to  /etc/motd.tail  and  stores  the
       resulting  file in /var/run/motd. /etc/motd is a symbolic link to /var/run/motd.  This is done to prevent changes to /etc as the system can
       not assume /etc to be writable.

       Changes to /etc/motd effectively end up in a file under /var/run which will be regenerated upon reboot.

       A symbolic link to a different file, such as /etc/motd.static disables this behaviour.

FILES

       /etc/init.d/bootmisc.sh
	      The initiation script which builds /var/run/motd

       /etc/motd
	      Symbolic link to the system message of the day at /var/run/motd

       /etc/motd.tail
	      Template for building the system message of the day

       /var/run/motd
	      System message of the day file rebuilt at each computer start

SEE ALSO

       login(1), issue(5), motd(5).

Debian								    2007-04-28							      MOTD.TAIL(5)