Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: big xml file with nested loop parse
Top Forums Shell Programming and Scripting big xml file with nested loop parse Post 302482450 by unclecameron on Tuesday 21st of December 2010 01:49:29 PM
Old 12-21-2010
big xml file with nested loop parse
I have an xml file with the structure:
Code:
<tag1>
      <value1>xyx</value1>
      <value2>123</value2>
</tag1>
<tag1>
      <value1>568</value1>
      <value2>zzzzz</value2>
</tag1>

where I want to parse each data pair in the this single file, so something like:
Code:
find first tag1 data pair
      xmlstarlet can get the data (I have this working)
      put that data in a database (I have this working)
go to next tag1 data pair

I don't know if I can make an awk loop with a FS of <>, or just use something like:
Code:
awk '/tag1/, /\/tag1/' sample.xml

which works for an individual data pair, but I just don't know how to build the right loop.
Last edited by unclecameron; 12-21-2010 at 03:07 PM..
This User Gave Thanks to unclecameron For This Post:
gmark99
 

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

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

3. 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

4. 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

5. Shell Programming and Scripting

AWK - Parse a big file

INPUT SAMPLE Symmetrix ID : 000192601507 Masking View Name : TS00P22_13E_1 Last updated at : 05:10:18 AM on Tue Mar 22,2011 Initiator Group Name : 10000000c960b9cd Host Initiators { WWN : 10000000c960b9cd } Port Group Name :... (8 Replies)
Discussion started by: greycells
8 Replies

6. 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

7. Shell Programming and Scripting

Using shell command need to parse multiple nested tag value of a XML file

I have this XML file - <gp> <mms>1110012</mms> <tg>988</tg> <mm>LongTime</mm> <lv> <lkid>StartEle=ONE, Desti = Motion</lkid> <kk>12</kk> </lv> <lv> <lkid>StartEle=ONE, Source = Velocity</lkid> <kk>2</kk> </lv> <lv> ... (3 Replies)
Discussion started by: NeedASolution
3 Replies

8. UNIX for Advanced & Expert Users

Convert CSV file to nested XML file using UNIX/PERL?

we have a CSV which i need to convert to XML using Perl or Unix shell scripting. I was able to build this XML in oracle database. However, SQL/XML query is running for long time. Hence, I'm considering to write a Perl or shell script to generate this XML file. Basically need to build this XML... (3 Replies)
Discussion started by: laknar
3 Replies

9. Emergency UNIX and Linux Support

Getting VALUE from Big XML File -- That's All

We got data that was supposed to be CSV, but was sent in a huge XML file. I've downloaded xmlstarlet, but I'm darned if I can get it to operate the "sel" feature to look down a path and get any sort of value. I see pieces of what should be paths, but they seem to have extraneous characters, and... (7 Replies)
Discussion started by: gmark99
7 Replies

10. Shell Programming and Scripting

Split Big XML file Base on tag

HI I want to split file base on tag name. I have few header and footer on file <?xml version="1.33" encing="UTF-8"?> <bulkCmConfigDataFile" <xn:SubNetwork id="ONRM_ROOT"> <xn:MeContext id="PPP04156"> ... (4 Replies)
Discussion started by: pareshkp
4 Replies

LEARN ABOUT DEBIAN

__gnu_parallel::lexicographic

__gnu_parallel::lexicographic< T1, T2, Comparator >(3cxx)				 __gnu_parallel::lexicographic< T1, T2, Comparator >(3cxx)

NAME

       __gnu_parallel::lexicographic< T1, T2, Comparator > -

SYNOPSIS

       Inherits std::binary_function< std::pair< T1, T2 >, std::pair< T1, T2 >, bool >.

   Public Types
       typedef std::pair< T1, T2 > first_argument_type
       typedef bool result_type
       typedef std::pair< T1, T2 > second_argument_type

   Public Member Functions
       lexicographic (Comparator &_comp)
       bool operator() (const std::pair< T1, T2 > &p1, const std::pair< T1, T2 > &p2) const

Detailed Description
   template<typename T1, typename T2, typename Comparator>class __gnu_parallel::lexicographic< T1, T2, Comparator >
       Compare a pair of types lexicographically, ascending.

       Definition at line 55 of file multiseq_selection.h.

Member Typedef Documentation
   typedef std::pair< T1, T2 >	std::binary_function< std::pair< T1, T2 > , std::pair< T1, T2 > , bool	>::first_argument_type [inherited]
       the type of the first argument (no surprises here)

       Definition at line 114 of file stl_function.h.

   typedef bool  std::binary_function< std::pair< T1, T2 > , std::pair< T1, T2 > , bool  >::result_type [inherited]
       type of the return type

       Definition at line 118 of file stl_function.h.

   typedef std::pair< T1, T2 >	std::binary_function< std::pair< T1, T2 > , std::pair< T1, T2 > , bool	>::second_argument_type [inherited]
       the type of the second argument

       Definition at line 117 of file stl_function.h.

Author
       Generated automatically by Doxygen for libstdc++ from the source code.

libstdc++							  Thu Aug 2 2012	 __gnu_parallel::lexicographic< T1, T2, Comparator >(3cxx)
All times are GMT -4. The time now is 09:20 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy