Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: sed parse small xml file
Top Forums Shell Programming and Scripting sed parse small xml file Post 302414235 by unclecameron on Monday 19th of April 2010 02:51:07 PM
Old 04-19-2010
sed parse small xml file
I have a tmp.xml file like:
Code:
<?xml version="1.0" encoding="UTF-8"?>
<Response>
  <Ip>193.143.121.198</Ip>
  <Status>OK</Status>
  <CountryCode>PL</CountryCode>
  <CountryName>Poland</CountryName>
  <RegionCode>82</RegionCode>
  <RegionName>Pomorskie</RegionName>
  <City>Gdansk</City>
  <ZipPostalCode></ZipPostalCode>
  <Latitude>54.35</Latitude>
  <Longitude>18.6667</Longitude>
  <Timezone>0</Timezone>
  <Gmtoffset>0</Gmtoffset>
  <Dstoffset>0</Dstoffset>
</Response>

where I'm trying to search for specific fields like this:
Code:
cc=`grep CountryCode tmp.xml | tr -d '\t' | sed 's/^<.*>\([^<].*\)<.*>$/\1/' `
echo $cc
rn=`grep RegionName tmp.xml | tr -d '\t' | sed 's/^<.*>\([^<].*\)<.*>$/\1/' `
echo $rn
ct=`grep City tmp.xml | tr -d '\t' | sed 's/^<.*>\([^<].*\)<.*>$/\1/' `
echo $ct

which outputs
Code:
<CountryCode>PL</CountryCode>
<CountryName>Poland</CountryName>
<RegionName>Pomorskie</RegionName>
<City>Gdansk</City>

I want an ouput like:
Code:
PL
Poland
Pomorskie
Gdansk

what is wrong with my sed command and is there a better/more elegant way to do this?
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

How to parse a XML file using PERL and XML::DOm

I need to know the way. I have got parsing down some nodes. But I was unable to get the child node perfectly. If you have code please send it. It will be very useful for me. (0 Replies)
Discussion started by: girigopal
0 Replies

2. Shell Programming and Scripting

Parse XML file

Hi, I need to parse the following XML data enclosed in <a> </a> XML tag using shell script. <X> ..... </X> <a> <b> <c>data1</c> <c>data2</c> </b> <d> <c>data3</c> </d> </a> <XX> ... </XX> (5 Replies)
Discussion started by: viki
5 Replies

3. Shell Programming and Scripting

How can I parse xml file?

How can I parse file containing xml ? I am sure that its best to use perl - but my perl is not very good - can someone help? Example below contents of file containing the xml - I basically want to parse the file and have each field contained in a variable.. ie. I want to store the account... (14 Replies)
Discussion started by: frustrated1
14 Replies

4. Emergency UNIX and Linux Support

How to parse the following xml file

Hi, I have the following file Example.xml <?xml version="1.0" encoding="iso-8859-1"?> <html><set label="09/07/29" value="1241.90"/> </html> Can any one help me in parsing this xml file I want to retrive the attribute values of the tag set Example I want to... (3 Replies)
Discussion started by: Raji_gadam
3 Replies

5. Shell Programming and Scripting

xmlstarlet template parse small xml file

I have a file like: <?xml version="1.0" encoding="UTF-8" standalone="no"?> <geonames> <geoname> <toponymName>Palos Verdes</toponymName> <name>Palos Verdes</name> <lat>42.1628912</lat> <lng>-123.6481235</lng> <geonameId>5718340</geonameId> <countryCode>US</countryCode>... (4 Replies)
Discussion started by: unclecameron
4 Replies

6. Shell Programming and Scripting

parse xml file

Hello all, Given the following extract from a xml file with multiple <JOB> .... </JOB> entries <JOB APPLICATION="APP" APR="0" AUG="0" AUTHOR="AUT" AUTOARCH="0" CMDLINE="/tmp/test1 %%var" CONFIRM="1" CREATION_DATE="20100430" CREATION_TIME="130739" ... (2 Replies)
Discussion started by: cabrao
2 Replies

7. Programming

Parse XML file

How do I get the field info for tags ID, NAME, DESCRIPTION. Below is my current code put I can't get beyond the first_child of the file. use strict; use warnings; use XML::Simplehttp://images.intellitxt.com/ast/adTypes/icon1.png; use... (1 Reply)
Discussion started by: leemalloy
1 Replies

8. UNIX for Dummies Questions & Answers

Parse xml file

HI Guys, Input .XML <xn:MeContext id="L0307"> <xn:ManagedElement id="1"> <xn:VsDataContainer id="1"> <xn:attributes> <xn:vsDataType>vsDataENodeBFunction</xn:vsDataType> ... (3 Replies)
Discussion started by: pareshkp
3 Replies

9. Shell Programming and Scripting

Parse XML File.

HI Guys I have Below XML File : <xn:SubNetwork id="XYZ"> <xn:SubNetwork id="C01"> <xn:MeContext id="CO1"> <xn:ManagedElement id="1"> <un:RncFunction id="1"> <un:UtranCell id="NY431"> ... (2 Replies)
Discussion started by: pareshkp
2 Replies

10. Shell Programming and Scripting

Parse xml file

I am trying to create a shell script that will parse an xml file (file attached). awk '/Id v=/ { print }' Test.xml | sed 's!<Id v=\"\(.*\)\"/>!\1!' > output.txt An output.txt file is created but it is empty. It should contain the value 222159 in it. Thanks. (7 Replies)
Discussion started by: cmccabe
7 Replies

LEARN ABOUT DEBIAN

stag-autoschema

STAG-AUTOSCHEMA(1p)					User Contributed Perl Documentation				       STAG-AUTOSCHEMA(1p)

NAME

       stag-autoschema - writes the implicit stag-schema for a stag file

SYNOPSIS

	 stag-autoschema -w sxpr sample-data.xml

	 stag-autoschema -dtd sample-data.xml

DESCRIPTION

       Takes a stag compatible file (xml, sxpr, itext), or a file in any format plus a parser, and writes out the implicit underlying stag-schema

       stag-schema should look relatively self-explanatory.

       Here is an example stag-schema, shown in sxpr syntax:

	 (db
	  (person*
	   (name "s"
	   (address+
	    (address_type "s")
	    (street "s")
	    (street2? "s")
	    (city "s")
	    (zip? "s")))))

       The database db contains zero or more persons, each person has a mandatory name and at least one address.

       The cardinality mnemonics are as follows:

       +   1 or more

       ?   0 or one

       *   0 or more

       The default cardinality is 1

ARGUMENTS

       -p|parser FORMAT
	   FORMAT is one of xml, sxpr or itext, or the name of a perl module

	   xml assumed as default

       -dtd
	   exports schema as DTD

       -w|writer FORMAT
	   FORMAT is one of xml, sxpr or itext, or the name of a perl module, OR DTD

	   The default is sxpr

	   note that stag schemas exported as xml will be invalid xml, due to the use of symbols *, +, ? in the node names

LIMITATIONS

       not event based - memory usage becomes exhorbitant on large files; prepare a small sample beforehand

perl v5.10.0							    2008-12-23						       STAG-AUTOSCHEMA(1p)
All times are GMT -4. The time now is 08:57 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy