topic Re: Ignore 1st adn 2nd in Operating System - HP-UX

Ignore 1st adn 2nd

chinnaga — Mon, 12 Mar 2007 02:56:37 GMT

Hi ,

I am trying to loop through a text file and I want to ignore the 1st and the last line in the file. HOw can I achive this without using tail and head.

for example

START|
1|RECV1_PLCMM_1_YYYYMMDD_HHMMSS_DATA.TXT|
2|RECV1_PLCMM_2_YYYYMMDD_HHMMSS_DATA.TXT|
3|RECV1_PLCMM_3_YYYYMMDD_HHMMSS_DATA.TXT|
4|RECV1_PLCMM_4_YYYYMMDD_HHMMSS_DATA.TXT|
5|RECV1_PLCMM_5_YYYYMMDD_HHMMSS_DATA.TXT|
END|

I want to ignore START and END in the file.

Could u pls help me with this

Re: Ignore 1st adn 2nd

Oviwan — Mon, 12 Mar 2007 03:03:42 GMT

Hey

perl -lane 'print if !/START/ && !/END/' < yourfile

you can bind this in a loop...

Regards

Re: Ignore 1st adn 2nd

SANTOSH S. MHASKAR — Mon, 12 Mar 2007 03:28:09 GMT

awk -F | '$1 != "START" && $1 != "END" '{print $0}' ur_file_name

-Santosh

Re: Ignore 1st adn 2nd

Peter Godron — Mon, 12 Mar 2007 03:38:17 GMT

Hi,
elimination before processing:
grep -v -e'^START' -e'^END' data.lis

Eliminiation during processing:
while read record
do
if [ $"record" = "START" ] -o [ "$record" = "END" ]
then
echo skipped record
else
echo process record
fi
done < data.lis

Re: Ignore 1st adn 2nd

Peter Godron — Mon, 12 Mar 2007 04:54:29 GMT

Hi,
or if your requirement is not tied to START/END phrase:

# Get the number of lines in data file
a=`wc -l g.lis | cut -d' ' -f1`
# Subtract one for the last line
b=`echo "$a - 1" | bc`
# Echo all but the first and last line
sed -n "2,$b p" data.lis

Please also read:
http://forums1.itrc.hp.com/service/forums/helptips.do?#33 on how to reward any useful answers given to your questions.

So far you have not awarded any points !

Re: Ignore 1st adn 2nd

Hein van den Heuvel — Mon, 12 Mar 2007 07:50:13 GMT

I think the easiest way it to stash the current record away and process the prior.
Start processing after the second to skip the first.

In perl:

perl -ne "print $last if $.>2; $last=$_" some-text-file

fwiw,
Hein.

Re: Ignore 1st adn 2nd

James R. Ferguson — Mon, 12 Mar 2007 07:57:03 GMT

Hi:

Here's another generalized way to skip the first and the last record in a file. Notice that this is not dependent upon any pattern matching:

# perl -ne 'print if $. > 1 and !eof' file

Regards!

...JRF...

Re: Ignore 1st adn 2nd

James R. Ferguson — Mon, 12 Mar 2007 09:00:33 GMT

Hi (again):

If you won't accept a particular language for your solution, then *say so* when you ask for help so that we don't waste our time!!!

...JRF...

Re: Ignore 1st adn 2nd

chinnaga — Mon, 12 Mar 2007 09:31:42 GMT

I am sorry for the inconvience .