Capturing string between a xml tag - Shell Programming and Scripting

amit_iti · #1 05-14-2008

Hi All,
I have an XML-:

Code:

       <ProcId>CES_P5010_AddVLan</ProcId>
        <DataVersion>yxcxycyxcycyxc</DataVersion>
        <JobId>OR3000055-002-1</JobId>
          </CesHeader>
    <VLanServiceList>
        <NopId>blu</NopId>
    </VLanServiceList>
            <StatusNPA>2</StatusNPA>
        <ErrorTextNPA>Exception occurred trying to create Management Service :Exception occurred trying to create Service :Error Code=239023  [Virtual LAN: ].. ** </ErrorTextNPA>
    </NPAErrorHandling>
</CesResponse>

Here I want to have a shell script to get the string in the tag <ErrorTextNPA>*****<ErrorTextNPA>. Can any one help me on this.
Regards
Amit

era · #2 05-14-2008

Is this a single long line, or spanning over multiple lines?

As such, the following doesn't really care.

Code:

perl -0777 -pe 's%.*<ErrorTextNPA>%%s;s%</ErrorTextNPA>.*%%s' file

DukeNuke2 · #3 05-14-2008

moved the thread from solaris to shell scripting for this is not a solris specific question...

penchal_boddu · #4 05-14-2008

using sed,

cat filename | grep -e '<ErrorTextNPA>' | sed 's/<ErrorTextNPA>\(.*\)<\/ErrorTextNPA>/\1/'
Thanks
Penchal

era · #5 05-14-2008

Actually the cat and grep are redundant.

Code:

sed -n 's%.*<ErrorTextNPA>\(.*\)</ErrorTextNPA>.*%\1%p' file.xml

However, it won't work if the open and close tags are on different lines. (There are ways to cope with that in sed, too, of course.)

fpmurphy · #6 05-14-2008

Quote:

<ProcId>CES_P5010_AddVLan</ProcId>
<DataVersion>yxcxycyxcycyxc</DataVersion>
<JobId>OR3000055-002-1</JobId>
</CesHeader>
<VLanServiceList>
<NopId>blu</NopId>
</VLanServiceList>
<StatusNPA>2</StatusNPA>
<ErrorTextNPA>Exception occurred trying to create Management Service :Exception occurred trying to create Service :Error Code=239023 [Virtual LAN: ].. **
</ErrorTextNPA>
</NPAErrorHandling>
</CesResponse>

The best way to handle this type of problem is to use an XSLT processor together with an XSL stylesheet to transform the XML document into whatever output you want - in this case the contents of the XML element <ErrorTextNPA>. UNIX command line tool such as awk, sed, etc were never designed to efficiently handle XML documents.

I would note that this is not possible for the supplied XML document since it is not a well-formed or valid XML document (missing root, missing opening tags, etc.)

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
Capturing stdin	domivv	Shell Programming and Scripting	3	01-24-2008 01:30 PM
capturing log	mgirinath	Shell Programming and Scripting	3	05-16-2006 08:21 AM
Capturing text between ()	sysera	Shell Programming and Scripting	7	06-14-2005 08:37 AM
Capturing value into variable	prasad01	Shell Programming and Scripting	2	08-19-2003 12:38 PM
capturing process id	bvreddy	Shell Programming and Scripting	1	09-16-2002 01:08 PM

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode