How to get data from xml files tags(from data tags)
 

hi I have a tag in XML file in unix like this

<EmailAddress>abc@gmail.com</EmailAddress>

this tag is there for multiple times in the xml file and the data is in continuous line like below

<State>UN</State><Zip/><CompanyName/><EmailAddress>FDF@gmail.COM</EmailAddress><PromoType>UNKNOWN</PromoType></Promotion></PromotionList<State>UN</State><Zip/><CompanyName/><EmailAddress>zd4946@gmail.com</EmailAddress>

I have to check the data in between bold tags is valid or not ... means have to check whether its a email address or not

and have to find the length of the attribute means tag ...script is in ksh

sorry if its already asked...i checked but i didnt get Exatly matching result for my requirement


any help in this

You could try to write a regular expression to do this, but parsing xml, html, etc. is notoriously difficult. If ksh is like Bash in terms of syntax, that sounds like trying to sculpt a piece of marble with a spoon. I would recommend looking at a scripting language with XML parsers available (eg, Perl, Python or Ruby).

I think we can get with awk ... I got the answer but works with 1st occurance of the <EmailAddress></EmailAddress> tag only

but i need for multiple times .... means email address tag exists for multiple times in the file ...
so need to check whole xml file for email address wherever <EmailAddress></EmailAddress> tag is present.

Concur with Telemachos

what that means

http://dictionary.reference.com/dic?...&search=search
:)

Take a look at egrep's multiline/return regex searching. It will allow you to parse the file for each occurrance of <></> and then pipe that to another egrep that uses -v and looks for <></>.

kingmaker2003 -

I concur with Telemachos and Chrism01. Do yourself a big favor, and learn just enough Perl to parse a little bit of your file. Then see how easy it is to call Perl from your script. Just try it - and I think you'll concur, too.

IMHO .. PSM