Problem printing the property of xml file via shell script

neeto · #1 (**permalink**) 04-16-2008

Hi,
I have a config.xml which cointains the tags like
<CONFIG>
<PROPERTY name="port" value="1111"/>
<PROPERTY name="dbname" value="ABCDE"/>
<PROPERTY name="connectstring" value="xyz/pwd"/>
</CONFIG>
This file is in some directory at UNix box.
I need to write a shell script to echo the dbname.

Please help me with the sample shell script fpr this.

Thanks in advance

era · #2 (**permalink**) 04-16-2008

Code:

sed -n 's%<PROPERTY name="dbname" value="\([^"]*\)".*%\1%p' file.xml

The proper way to do it is with XSLT but if this is all you need, that's overkill.

danmero · #3 (**permalink**) 04-16-2008

Code:

 awk -F'"' '$2=="dbname" {print $4}' file.xml

neeto · #4 (**permalink**) 04-16-2008

Thanks for the reply..
But is there a way to do this in awk?

Neha

shamrock · #5 (**permalink**) 04-16-2008

Code:

[n]awk '{
  if ($2 ~ /dbname/) {
     gsub(/(^.*=\"|\"\/>$)/,"",$NF)
     print $NF
  }
}' file

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
URGENT: Script/Function needed to read text property files in block wise	ysreenivas	Shell Programming and Scripting	7	05-11-2009 03:08 AM
Problem with Calling sql file from shell script	sskc	Shell Programming and Scripting	1	05-03-2007 05:20 PM
printing last argument in shell script	arunkumar_mca	Shell Programming and Scripting	5	10-03-2006 08:32 PM
Problem with SU or SSH in shell script	sravanp	UNIX for Dummies Questions & Answers	2	01-24-2006 12:00 PM
end of file problem with shell script	whatisthis	Shell Programming and Scripting	5	10-20-2004 03:20 PM

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode	Rate This Thread:


	Powered by