sed xml challenge


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting sed xml challenge
# 1  
Old 04-10-2008
Error sed xml challenge

I have a web xml file that looks like this:

Code:
<allinfo>
    <info>
          <a>Name1<\a>
          <b>address1<\b>
           <c>phone1<c>
    <\info>
    <info>
          <a>Name2<\a>
          <b>address2<\b>
          <c>phone2<c>
<\info>
<\allinfo>

I want to use sed to extract all the informations.
for instance, the output for the xml above would be:

Name: Name1
address: address1
phone: phone1

Name: Name2
address: address2
phone: phone2

I thought of few ways of doing it, but right now I'm stuck on the sed code.

Any help would be great

Thank you
# 2  
Old 04-10-2008
Show us what you have.
# 3  
Old 04-10-2008
The website file you presented here was not valid or well-formed xml document

The following is a well-formed and valid xml document:
Code:
<allinfo>
    <info>
          <a>Name1</a>
          <b>address1</b>
          <c>phone1</c>
    </info>
    <info>
          <a>Name2</a>
          <b>address2</b>
          <c>phone2</c>
    </info>
</allinfo>

The best way to transform an XML document to use an XSLT processor. xsltproc is such a processor and is very common on UNIX and Linus systems.

Here is a stylesheet which will transform the XML document into the output you want.
Code:
<?xml version="1.0"?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<xsl:<xsl:output method="text" />

<xsl:template match="/allinfo/info">
Name: <xsl:value-of select="a"/>
Address: <xsl:value-of select="b"/>
Phone: <xsl:value-of select="c"/>
</xsl:template>

</xsl:stylesheet>

xsltproc file.xsl file.xml produces the following output:
Code:
Name: Name1
Address: address1
Phone: phone1

Name: Name2
Address: address2
Phone: phone2

Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Bit of sed help in XML

Hi all, need some help seeing the bug in my SED Source XML <SMART_FOLDER JOBISN="1" SUB_APPLICATION="PMT-APB" MEMNAME="Job0" JOBNAME="PMT-APB" FOLDER_NAME="PMT-APB"> </SMART_FOLDER> My SED Command sed -e 's/\(<SMART_FOLDER \)\(.*FOLDER_NAME="PMT-APB"\)/\FOLDER_ORDER_METHOD="PCI" \2/' <... (0 Replies)
Discussion started by: J-Man
0 Replies

2. UNIX for Advanced & Expert Users

Interesting awk/Perl/sed parsing challenge

I have a log with entries like: out/target/product/imx53_smd/obj/STATIC_LIBRARIES/libwebcore_intermediates/Source/WebCore/bindings/V8HTMLVideoElement.cpp : target thumb C++: libwebcore <=... (8 Replies)
Discussion started by: glev2005
8 Replies

3. Shell Programming and Scripting

sed extract from xml

I have an xml file that generally looks like this: "<row><dnorpattern>02788920</dnorpattern><description/></row><row><dnorpattern>\+ 44146322XXXX</dnorpattern><description/></row><row><dnorpattern>40XXX</dnorpattern><description/></row><row><dnorpattern>11</dn... (4 Replies)
Discussion started by: garboon
4 Replies

4. Shell Programming and Scripting

Again, Sed and Xml

Hi all, I have a xml file like below, <JavaArgs> <containerSet> <container id="333"> <JavaArgs> Very Big String </Javargs> </container> <container id="334"> ... (5 Replies)
Discussion started by: nasbtv
5 Replies

5. Shell Programming and Scripting

sed and XML

I am trying to edit an XML file with sed, and I can successfully do so, but the resulting file no longer opens as an XML file? I am working on a project to automate DVD authoring. I am using DVD Studio Pro, which uses XML files as its instructions for DVD authoring. I've worked out a... (2 Replies)
Discussion started by: Starcast
2 Replies

6. Shell Programming and Scripting

SED extract XML value

I have the following string: <min-pool-size>2</min-pool-size> When I pipe the string into the following code I am expcting for it to return just the value "2", but its just reurning the whole string. Why?? sed -n '/<min-pool-size>/,/<\/min-pool-size>/p' Outputting:... (13 Replies)
Discussion started by: ArterialTool
13 Replies

7. Shell Programming and Scripting

sed replacement, challenge one!!!!

Hi all, Thanks in advanced. This question really bothered me much. What i want is to replace any times of repeated 'TB' to 'T', below is example. It can be fullfil by AWK and perl, but my desire is using SED to realize it. So here means we treat TB as a whole part, which means 's/TB*/T/'... (4 Replies)
Discussion started by: summer_cherry
4 Replies

8. UNIX for Dummies Questions & Answers

A challenge for you sed/awk wizards...

Here's a challenge for you wizards... I have a file formatted as follows; $ What I need to output is; 87654321 Bobby One 12345678 Bobby One 09876543 Bobby One 1107338 Bobby! Two Any Ideas how I can do this? I've tried sed but I'm not sure if perl might be a better way to... (2 Replies)
Discussion started by: th3g0bl1n
2 Replies

9. Shell Programming and Scripting

SED for XML's

Hi My xml has element like below <BOOK>:</BOOK> If i wanna replace ":</BOOK>" with ": </BOOK>" i.e 3 spaces added. what should be the search pattern? I tried with "?:\<\/BOOK\>", but its not working in SED. Can someone suggest what would be the search patter looks like ? Thanks (1 Reply)
Discussion started by: braindrain
1 Replies

10. Shell Programming and Scripting

using sed with xml files

Hello I'm working on a project modifying XML files in Unix and, I would like to use sed to change these values. For example, I've got a tag <book>354678209<\book> and I want to replace the value 354678209 with a another value without having to go into the file and change it manually. How can I do... (3 Replies)
Discussion started by: stonemonolith
3 Replies
Login or Register to Ask a Question

Featured Tech Videos