topic Re: parsing text by scripting in Operating System - HP-UX

parsing text by scripting

Sammy_2 — Tue, 25 Sep 2001 16:03:16 GMT

I want to parse a text file below (either in perl or shell scripting) so that I get
the last record that has the id no. The
first field within double quotes is always id no.
The input text file is below and the output I want to see is in the end. Can't figure it out.?
Help please.

INPUT FILE:
==========================
{"123", "sam", "Test"}
{"123", "sami", "Test Only"}
{"123", "samuel", "This is the record I want"}
{"345", "sharo19", "VICC eassocr"}
{"678", "pat", "Test2"}
{"678", "patrick1", "Real Test now"}
{"321", "sharo19", "VICC eassocr"}
===============================

OUTPUT NEEDED FROM THE ABOVE INPUT FILE is:
===========================================
{"123", "samuel", "This is the record I want"}
{"345", "sharo19", "VICC eassocr"}
{"678", "patrick1", "Real Test now"}
{"321", "sharo19", "VICC eassocr"}
===========================================

Re: parsing text by scripting

James R. Ferguson — Tue, 25 Sep 2001 16:47:01 GMT

Hi Sam:

Try this:

#!/usr/bin/sh
typeset MYFILE=$1
awk -F, 'BEGIN {TOG=0;D=$1;S=$0}
{if (TOG==1 && D!=$1)
{print S} TOG=1;D=$1;S=$0}
END {print S}' $MYFILE
exit 0
#.end.

Pass your input file as an arguement to the script above and you will get the desired output.

Regards!

...JRF...

Re: parsing text by scripting

James R. Ferguson — Tue, 25 Sep 2001 17:32:08 GMT

Hi (again) Sam:

Oops. The 'awk' BEGIN rule (although harmless) is superfluous. Actually no I/O has occured at that point and I should have dropped it, simplfying to:

#!/usr/bin/sh
typeset MYFILE=$1
awk -F, '{if (TOG==1 && D!=$1) {print S} TOG=1;D=$1;S=$0}
END {print S}' $MYFILE
exit 0
#.end.

Regards!

...JRF...

Re: parsing text by scripting

linuxfan — Tue, 25 Sep 2001 17:44:44 GMT

Hi Sam,

Here's another way to do it,

/Begin/
#!/usr/bin/sh

if [[ $# < 1 ]]
then
echo "Usage: $0 filename"
exit 1
fi

cat $1 |sort -n |cut -d \" -f 2 |uniq |while read id
do
grep "$id" "$inputfile" |tail -1
done

/End/

To run it
script.sh filename

-HTH
Ramesh

Re: parsing text by scripting

linuxfan — Tue, 25 Sep 2001 17:46:16 GMT

Re: parsing text by scripting

Curtis Larson_1 — Tue, 25 Sep 2001 17:48:42 GMT

cat yourFile |
awk '{
split($0,array,"\"");
id=array[2];
bigA[id]=$0;
} END {
for ( i in bigA )
print bigA[i];
}'

Re: parsing text by scripting

Sammy_2 — Tue, 25 Sep 2001 18:48:41 GMT

Thanks to James, Ramesh and Curtis.
All of your script did what I asked for .