topic Re: Grepping pattern from a File in Operating System - HP-UX

Grepping pattern from a File

Virumandi — Tue, 03 Oct 2006 03:45:42 GMT

Hi ,

I want to grep a particular pattern from a file...

The string will be like this...

multimediaGroup type="media" dbid="525"

I want to grep the dbid value say 525 from the file ...

How can I do it with sed or perl..

Re: Grepping pattern from a File

Virumandi — Tue, 03 Oct 2006 03:47:08 GMT

I dont know the dbid value But i am sure that it is a three digit numeric number..

Re: Grepping pattern from a File

Peter Godron — Tue, 03 Oct 2006 03:54:34 GMT

Hi,
if your input file format is consistent:
cat input.dat | grep dbid | awk -F'"' '{print $4}'

Please also start rewarding answers to your questions:
http://forums1.itrc.hp.com/service/forums/helptips.do?#28

Re: Grepping pattern from a File

Michal Toth — Tue, 03 Oct 2006 03:59:43 GMT

consistency is the key here ;-)

Re: Grepping pattern from a File

john korterman — Tue, 03 Oct 2006 04:04:14 GMT

Hi,

grep is grep:

grep "dbid=\"[0-9][0-9][0-9]\"$" /your_infile

regards,
John K.

Re: Grepping pattern from a File

Virumandi — Tue, 03 Oct 2006 04:08:28 GMT

Thanks for the command.
Its working fine..

But One more query,
Can we save the value in a variable..

Re: Grepping pattern from a File

Virumandi — Tue, 03 Oct 2006 04:27:03 GMT

Hi Peter..,

Your solution works but We cant able to assign the value we grepped to the variable..

Can u guide to me how to do the same.

Thanks...

Re: Grepping pattern from a File

Peter Godron — Tue, 03 Oct 2006 05:23:58 GMT

Hi,
if you only find a single dbid in the file:
a=`grep dbid | awk -F'"' '{print $4}'`

Otherwise:
while read record
do
a=`echo $record | grep dbid | awk -F'"' '{print $4}'`
echo "This is your variable value" $a
done < input.dat

Re: Grepping pattern from a File

Arturo Galbiati — Wed, 04 Oct 2006 02:43:19 GMT

Hi,
this retrun teh value in the variable dbid

dbid=$(awk -F"dbid=" '/dbid=/ {print $2}' file)

This command is indipendent by teh dbid position on the line. It founds line containg 'dbid=' and print the subsequent field. BY awk is not necessary to use cat and/or grep etc. awk is able to open a file.

HTH,
Art

Re: Grepping pattern from a File

Virumandi — Fri, 06 Oct 2006 00:57:24 GMT

Thanks to all...