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


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting how to get data from xml files tags(from data tags)
# 8  
Old 08-04-2008
Quote:
Originally Posted by Sarala Anugu
nawk -F">" '{print $2}' file | nawk -F"<" '{print $1}' | grep . | grep your-pattern

with this method you are not hardcoding the tagnames, instead we are getting the string between > and the following <

hence the output of this command is
sa865h@sipc306> nawk -F">" '{print $2}' file | nawk -F"<" '{print $1}' | grep .
redcolor
yellow color and it is

"grep ." will simply remove the empy lines

Hope it is useful!!!!!!!!!!!!!



thanks its working for my requirement
# 9  
Old 08-04-2008
Quote:
Originally Posted by Sarala Anugu
nawk -F">" '{print $2}' file | nawk -F"<" '{print $1}' | grep . | grep your-pattern

with this method you are not hardcoding the tagnames, instead we are getting the string between > and the following <

hence the output of this command is
sa865h@sipc306> nawk -F">" '{print $2}' file | nawk -F"<" '{print $1}' | grep .
redcolor
yellow color and it is

"grep ." will simply remove the empy lines

Hope it is useful!!!!!!!!!!!!!
Like that you call nawk two times and UselessUseOfGrep once .
What about:
Code:
awk -F'[<|>]' '$3 {print $3}' file


Last edited by danmero; 08-04-2008 at 08:16 PM..
# 10  
Old 08-16-2008
how to get file name too

how to get the file name also



Q)
i have a file like

<fruits>
<apple>redcolor<\apple>
<banana>yellow color and it is<\banana>
</fruits>

i need a text between apple and bannana ans so on....

how to read a text between a tags it multiple tags with differnt names


Quote:
Originally Posted by Sarala Anugu
nawk -F">" '{print $2}' file | nawk -F"<" '{print $1}' | grep . | grep your-pattern

with this method you are not hardcoding the tagnames, instead we are getting the string between > and the following <

hence the output of this command is
sa865h@sipc306> nawk -F">" '{print $2}' file | nawk -F"<" '{print $1}' | grep .
redcolor
yellow color and it is

"grep ." will simply remove the empy lines

Hope it is useful!!!!!!!!!!!!!
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Extracting data between continuous non empty xml tags

Hi, I need help in extracting only the phone numbers between the continuous non empty xml tags in unix. I searched through a lot of forum but i did not get exact result for my query. Please help Given below is the sample pipe delimited file. I have a lot of tags before and after... (6 Replies)
Discussion started by: zen01234
6 Replies

2. Shell Programming and Scripting

How can I replace data in between xml tags to required format?

Hi All, I have a requirement to change the data in xml file to required format. Below is the scenario. Please find the attached Xml file which contains data that I need to convert.. <ReleaseIndicatorList><ReleaseIndicator>Alternative... (0 Replies)
Discussion started by: Prathyu
0 Replies

3. UNIX for Advanced & Expert Users

Shell Script to read XML tags and the data within that tag

Hi unix Gurus, I am really new to Unix Scripting. Please help me to create a shell script which reads the xml file and from that i need to fetch a particular information. For example <SOURCE BUSINESSNAME ="" DATABASETYPE ="Teradata" DBDNAME ="DWPROD3" DESCRIPTION ="" NAME... (2 Replies)
Discussion started by: SmilePlease
2 Replies

4. Shell Programming and Scripting

Parsing XML (and insert data) then output data (bash / Solaris)

Hi folks I have a script I wrote that basically parses a bunch of config and xml files works out were to add in the new content then spits out the data into a new file. It all works - apart from the xml and config file format in the new file with XML files the original XML (that ends up in... (2 Replies)
Discussion started by: dfinch
2 Replies

5. Shell Programming and Scripting

Compare two xml files while ignoring some xml tags

I've got two different files and want to compare them. File 1 : <response ticketId="944" type="getQueryResults"><status>COMPLETE</status><description>Query results fetched successfully</description><recordSet totalCount="1" type="sms_records"><record id="38,557"><columns><column><name>orge... (2 Replies)
Discussion started by: Shaishav Shah
2 Replies

6. Shell Programming and Scripting

Shell script to extract data in repeating tags from xml

Hi, I am new to shell scripting. I need to extract data between repeating tags from an xml file and store the data in an array to process it further. <ns1:root xmlns:ns1="http://example.com/config"> <ns1:interface>in1</ns1:interface> <ns1:operation attribute1="true" attribute2="abd"... (2 Replies)
Discussion started by: sailendra
2 Replies

7. Shell Programming and Scripting

print xml data without the tags.

Hi All, I'm trying to extract data from an xml file but without the codes. I've achieved it but i was wondering if there's a better way to do this. sample data: $ cat xmlfile <code> <to>tove</to> <from>jani</from> <heading>reminder</heading> <body>dont forget me</body> </code> ... (4 Replies)
Discussion started by: Irishboy24
4 Replies

8. Shell Programming and Scripting

Data between XML Tags

<?xml version="1.0" encoding="iso-8859-1" ?> <TABLE> <TEST> <ID> 123 </ID> <name> abc </name> </TEST> <TEST> <ID> 123 </ID> <name> abc2 </name> </TEST> </TABLE> <TABLE> <TEST> <ID> 456 </ID> <name> def </name> </TEST> <TEST> ... (8 Replies)
Discussion started by: eskay
8 Replies

9. Shell Programming and Scripting

How to update data between xml tags

Is there a way to modify Non Null data between <host> and </host> tags to a new value ?- may be using sed/awk? I tried this sed 's|.*<host>\(?*\)</host>.*|\<host>xxx</host>|' but it is updating the host which has null value - want opposite of this - Thanks in advance for you help!! For... (2 Replies)
Discussion started by: harry_todd
2 Replies

10. UNIX for Dummies Questions & Answers

Removing leading and trailing spaces of data between the tags in xml.

I am having xml document as below. <transactionid> 00 </transactionid> <tracknumber> 0 </tracknumber> <key> N/A </key> But the data contains leading and trailing spaces between the tags. Please let me know how can i remove these leading and trailing spaces between the tags.... (2 Replies)
Discussion started by: jhmr7
2 Replies
Login or Register to Ask a Question