Retrieving related information 1

[ddrillich]

Good Day,

I have a config file that has a segment which looks like -

[Database1]
Name=Sports
ExpireIntoDatabase=SportArchive

[Database2]
Name=Entertainment

I need to grep, let's say, for Sports and return the corresponding DB name, in this case, Database1. I can assume safely that the DB line is one above the Name=Sports line.

Any thoughts?

Regards,
Dan

 

[feherke]

Hi

Just because you asked for :

grep -A 1 -F '[Database1]' /input/file | grep -v -F '[Database1]'

Otherwise [tt]awk[/tt] or [tt]sed[/tt] is much suitable for the task :

awk -F= '$0~/\[.*\]/{s=0}$0=="[Database1]"{s=1}s&&$1=="Name"{print$2}' /input/file

[gray]# or[/gray]

sed -n '/\[Database1\]/,/\[.*\]/s/^Name=//p' /input/file

With the [tt]awk[/tt] and [tt]sed[/tt] solutions the Name key can be anywhere in the given section and outputs only the value part.

Tested with GNU [tt]grep[/tt], [tt]gawk[/tt], [tt]mawk[/tt] and GNU [tt]sed[/tt].

Feherke.

http://free.rootshell.be/~feherke/

 

[ddrillich]

Many thanks feherke.

Not sure if I was clear enough. All that I have up-front is Sports, from there I would like to extract the DB name in the line above. In this case - Database1.

Regards,
Dan

 

[feherke]

Hi

Oops. Then the code changes abit, but my other comments are still valid :

grep -B 1 -F 'Name=Sports' /input/file | grep -v -F 'Name=Sports'

[gray]# or[/gray]

awk -F= '$2=="Sports"{print p}/^\[.*\]/{gsub(/[\[\]]/,"");p=$0}' /input/file

[gray]# or[/gray]

sed -n '/^Name=Sports/{g;s/[][]//g;p};/^\[.*\]/h' /input/file

Feherke.

http://free.rootshell.be/~feherke/

 

[ddrillich]

Magnificent - many thanks.

Regards,
Dan

 

[ddrillich]

About the lovely -

sed -n '/^Name=Sports/{g;s/[][]//g;p};/^\[.*\]/h' /input/file

How can I replace Sports with a variable?

Regards,
Dan

 

[Annihilannic]

You can just change the type of quotes and insert your variable:

sed -n "/^Name=$VARIABLE/{g;s/[][]//g;p};/^\[.*\]/h" /input/file

Annihilannic.

 

[ddrillich]

Thank you Annihilannic.