Need an efficient way to search for a tag in an xml file having millions of rows Post: 302603470

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

XML tag replacement from different XML file

We have 2 XML file 1. ORIGINAL.xml file and 2. ATTRIBUTE.xml files, In the ORIGINAL.xml we need some modification as <resourceCode>431048</resourceCode>under <item type="Manufactured"> tag - we need to grab the 431048 value from tag and pass it to database table in unix shell script to find the...

2. Shell Programming and Scripting

Changing particular tag value of xml file

Hi All, I have number of xml file like : ______________________________________________________ <?xml version="1.0" standalone="no"?>   <EToNrequest ...

3. Shell Programming and Scripting

How to retrieve the value from XML tag whose end tag is in next line

Hi All, Find the following code: <Universal>D38x82j1JJ </Universal> I want to retrieve the value of <Universal> tag as below: Please help me.

4. Shell Programming and Scripting

How to add the multiple lines of xml tags before a particular xml tag in a file

Hi All, I'm stuck with adding multiple lines(irrespective of line number) to a file before a particular xml tag. Please help me. <A>testing_Location</A> <value>LA</value> <zone>US</zone> <B>Region</B> <value>Russia</value> <zone>Washington</zone> <C>Country</C>...

5. Emergency UNIX and Linux Support

Trying to parse a xml file for only one tag

I have a xml file in where I need to parse only a particular tag and print the output in the shell script. Here is the tag info in the xml file <dp:file> This is dp file output </dp:file> Output should be printed as This is dp file output. Please help.Thank you.

6. Shell Programming and Scripting

To search for a particular tag in xml and collate all similar tag values and display them count

I want to basically do the below thing. Suppose there is a tag called object1. I want to display an output for all similar tag values under heading of Object 1 and the count of the xmls. Please help File: <xml><object1>house</object1><object2>child</object2>...

7. Shell Programming and Scripting

Efficient way to search array in text file by awk

I have one array SPLNO with approx 10k numbers.Now i want to search the subscriber number from MDN.TXT file (containing approx 1.5 lac record)from the array.if subscriber number found in array it will perform below operation.my issue is that it's taking more time because for one number it's search...

8. Shell Programming and Scripting

sed search and replace after xml tag

Hi All, I'm new to sed. In following XML file <interface type='direct'> <mac address='52:54:00:86:ce:f6'/> <source dev='eno1' mode='bridge'/> <model type='virtio'/> <address type='pci' domain='0x0000' bus='0x00' slot='0x03' function='0x0'/> </interface> ...

9. Shell Programming and Scripting

Moving XML tag/contents after specific XML tag within same file

Hi Forum. I have an XML file with the following requirement to move the <AdditionalAccountHolders> tag and its content right after the <accountHolderName> tag within the same file but I'm not sure how to accomplish this through a Unix script. Any feedback will be greatly appreciated. ...

10. UNIX for Beginners Questions & Answers

Grepping multiple XML tag results from XML file.

I want to write a one line script that outputs the result of multiple xml tags from a XML file. For example I have a XML file which has below XML tags in the file: <EMAIL>***</EMAIL> <CUSTOMER_ID>****</CUSTOMER_ID> <BRANDID>***</BRANDID> Now I want to grep the values of all these specified...

LEARN ABOUT MOJAVE

xpath

XPATH(1p)                                               User Contributed Perl Documentation                                              XPATH(1p)

NAME

       xpath - a script to query XPath statements in XML documents.

SYNOPSIS

       xpath [-s suffix] [-p prefix] [-q] -e query [-e query] ... [file] ...

DESCRIPTION

       xpath uses the XML::XPath perl module to make XPath queries to any XML document. The XML::XPath module aims to comply exactly to the XPath
       specification at "http://www.w3.org/TR/xpath" and yet allows extensions to be added in the form of functions.

       The script takes any number of XPath pointers and tries to apply them to each XML document given on the command line. If no file arguments
       are given, the query is done using "STDIN" as an XML document.

       When multiple queries exist, the result of the last query is used as context for the next query and only the result of the last one is
       output.  The context of the first query is always the root of the current document.

OPTIONS

   -q
       Be quiet. Output only errors (and no separator) on stderr.

   -s suffix
       Place "suffix" at the end of each entry. Default is a linefeed.

   -p prefix
       Place "prefix" preceding each entry. Default is nothing.

BUGS

       The author of this man page is not very fluant in english. Please, send him (fabien@tzone.org) any corrections concerning this text.

       See also XML::XPath(3pm).

SEE ALSO

       XML::XPath(3pm).

HISTORY

       This module is copyright 2000 Fastnet Software Ltd. This is free software, and as such comes with NO WARRANTY. No dates are used in this
       module. You may distribute this module under the terms of either the Gnu GPL,  or under specific licencing from Fastnet Software Ltd.
       Special free licencing consideration will be given to similarly free software. Please don't flame me for this licence - I've put a lot of
       hours into this code, and if someone uses my software in their product I expect them to have the courtesy to contact me first.

       Full support for this module is available from Fastnet Software Ltd on a pay per incident basis. Alternatively subscribe to the Perl-XML
       mailing list by mailing lyris@activestate.com with the text:

               SUBSCRIBE Perl-XML

       in the body of the message. There are lots of friendly people on the list, including myself, and we'll be glad to get you started.

       Matt Sergeant, matt@sergeant.org

       This man page was added as well as some serious modifications to the script by Fabien Ninoles <fabien@debian.org> for the Debian Project.

perl v5.10.1                                                        2009-12-30                                                           XPATH(1p)