UNIX for Dummies Questions & Answers

Is the only way to put in a header row to actually create another file to concatenate it with?

Create a file with

Code:

USERNAME	ACCT_STATUS	LOCK_DT	EXPIRY_DT	CREATED	PROFILE	SIDBA	EXPCTD_PROFILE	REMARKS

in it called "header-row".

Code:

mv QrtlyDBUsers.xls data-rows
cat header-row data-rows >QrtlyDBUsers.xls

of course file names are just suggestions.

or

Code:

mv QrtlyDBUsers.xls data-rows
cat - data-rows >QrtlyDBUsers.xls <<EOF
USERNAME	ACCT_STATUS	LOCK_DT	EXPIRY_DT	CREATED	PROFILE	SIDBA	EXPCTD_PROFILE	REMARKS
EOF

Hey Porter,

Hmm well I think I have confused the group. The column names (username, etc) are good and they are appearing at the top of the column and data is lining up etc..
what I was hoping to do is add the line of 'Audit Report: 12/07/2007' before the start of the column names Username, Acct_status, etc..

Audit Report: 12/07/2007
USERNAME ACCT_STATUS LOCK_DT EXPIRY_DT CREATED PROFILE SIDBA REMARKS


Thanks for your time.

I would do it the same way

Code:

echo "This is my report generated on"  `date` | cat - data-rows >finals.xls

Thanks for your help Porter!