Grepping pattern from a File

[Virumandi]

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..

[Virumandi]

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

[Peter Godron · Accepted solution]

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

[Michal Toth]

consistency is the key here ;-)

[john korterman]

Hi,

grep is grep:

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


regards,
John K.

[Virumandi]

Thanks for the command.
Its working fine..

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

[Virumandi]

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...

[Peter Godron]

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

[Arturo Galbiati]

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

[Virumandi]

Thanks to all...