Cuting specified line from a text file 3

[FlashGorden]

Hi

I have managed to take a text file with fields delimited with a | and add a unique number. My only problem is that the file has a header and footer.

I need a command to remove the header and footer and then insert then after I've updated the primary key.

Thanks

 

[grega]

Not easily done with a command, but this shell script should get you started.

#!/bin/ksh
# topntail.sh - remove 1st & last line of a file, do stuff and
# stick it back together again

# check that filename supplied
[ $# != 1 ] && {
echo "Need a filename"
exit 1
}

FILE=$1
LINES=`cat $FILE|wc -l`
TAIL=`expr $LINES - 2`

# save header & footer
head -1 $FILE > header.txt
tail -1 $FILE > footer.txt

# get the main section of the file
tail +2 $FILE | head -$TAIL > mainfile.txt

# do the primary key stuff here
#
#

# put the file back together again
cat header.txt mainfile.txt footer.txt > newfile.txt

Post back it there are any probs.

Greg.

 

[trunix]

This may be easier ...
Using piped tail commands ...
This assumes your file has single line headers and footers

tail -r filename | tail +2 | tail -r | tail +2

Read the tail man page for an explanation ....

"The power of Unix"

 

[gregor weertman]

This assumes your file has single line headers and footers

awk -v ll="`cat Yourfile.txt|wc -l`" '{
if( NR > 1 && NR < ll) print
}' Yourfile.txt Gregor.Weertman@mailcity.com