extracting XML file using sed

pujansrt · #1 (**permalink**) 06-28-2007

Hello folks

I want to extract data between certain tag in XML file using 'sed'
<xml>
.........
..........
<one>XXXXXXXXXXXXXXXXXXXX</one>
......

Anyone ?Thank you

Shell_Life · #2 (**permalink**) 06-28-2007

Code:

typeset -i mCnt
mFlag='N'
while read mLine
do
  mCnt=`echo $mLine | egrep -c '<one>'`
  if [ $mCnt -ne 0 ]; then
    mFlag='Y'
  fi
  if [ "$mFlag" = "Y" ]; then
    mOutLine=`echo $mLine | sed 's:<one>::;s:</one>::'`
    if [ "$mOutLine" != "" ]; then
      echo $mOutLine
    fi
  fi
  mCnt=`echo $mLine | egrep -c '</one>'`
  if [ $mCnt -ne 0 ]; then
    mFlag='N'
  fi
done < input_file

matrixmadhan · #3 (**permalink**) 06-28-2007

Could you please post more appropriate input and output ?

pujansrt · #4 (**permalink**) 06-28-2007

<MiniTable id="BrowserMiniTable">
<Row>
<Value>66.17%</Value><Key>InternetExplorer</Key>
</Row>
<Row>
<Value>27.39%</Value><Key>Firefox</Key>
</Row>
</MiniTable>

<MiniTable id="ConnectionTable">
<Row>
<Value>4.56</Value><Key>InternetExplorer</Key>
</Row>
<Row>
<Value>4.23</Value><Key>Firefox</Key>
</Row>
</MiniTable>
------------------------------------------------------------------
There are many <MiniTable> but I wanted only first one i.e. <MiniTable id="BrowserMiniTable"> 's content only in following form---

OUTPUT:
Browser----%
InternetExplorer----66.17
Firefox----27.39

Thanks dude

Shell_Life · #5 (**permalink**) 06-28-2007

Pujansrt,
Now you learned how important it is to follow the rules:

Quote:

(A) Include as many pertinent details as possible in your post.
...<more left out>...

The solution that I gave works with your first requirement.

anbu23 · #6 (**permalink**) 06-29-2007

Code:

sed -n "/BrowserMiniTable/,/MiniTable/s/<Value>\([^%]*\)%*<\/Value><Key>\(.*\)<\/Key>/\2-----\1/p" filename

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
How to view the contents of .gz file without extracting the file?	amitkhiare	Shell Programming and Scripting	10	12-18-2008 05:59 AM
Extracting from a tar file	nmalencia	UNIX Desktop for Dummies Questions & Answers	1	03-22-2008 06:42 AM
Extracting data from text file based on configuration set in config file	suparnbector	Shell Programming and Scripting	3	08-10-2007 02:25 AM
[Splitting file] Extracting group of segments from one file to others	ozgurgul	Shell Programming and Scripting	1	09-14-2006 12:17 PM
extracting from a tar file	Reza Nazarian	UNIX for Dummies Questions & Answers	4	03-24-2006 05:54 AM

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