About XML file Integrating to a table Post: 302319224

Sponsored Content

Top Forums UNIX for Advanced & Expert Users About XML file Integrating to a table Post 302319224 by TonyFullerMalv on Sunday 24th of May 2009 05:07:07 PM

05-24-2009

Registered User

To ensure that the "Attempts" line counter is always "1" and the "Successful Attempts" line counter is always "2" you could run each xml file through the following script before importing it into Oracle:

Code:

 sed -e '/Attempts/s/mt p="2"/mt p="1"/' -e '/Successful Attempts/s/mt p="1"/mt p="2"/'   inputfile.xml > outputfile.xml

Example run thorugh:

Code:

$ cat inputfile.xml
<mt p="1">Attempts</mt>
<mt p="2">Successful Attempts</mt>
<mt p="2">Attempts</mt>
<mt p="1">Successful Attempts</mt>
<mt p="2">Attempts</mt>
<mt p="2">Successful Attempts</mt>
<mt p="1">Attempts</mt>
<mt p="1">Successful Attempts</mt>
$ sed -e '/Attempts/s/mt p="2"/mt p="1"/' -e '/Successful Attempts/s/mt p="1"/mt p="2"/' inputfile.xml > outpufile.xml
$ cat outpufile.xml
<mt p="1">Attempts</mt>
<mt p="2">Successful Attempts</mt>
<mt p="1">Attempts</mt>
<mt p="2">Successful Attempts</mt>
<mt p="1">Attempts</mt>
<mt p="2">Successful Attempts</mt>
<mt p="1">Attempts</mt>
<mt p="2">Successful Attempts</mt>
$

TonyFullerMalv

View Public Profile for TonyFullerMalv

Find all posts by TonyFullerMalv

8 More Discussions You Might Find Interesting

1. Programming

about wave file integrating.

Now I have two wave file(*.wav) at Tru64 Unix machine. I want to make a new wave file including the two wave file. how I should finish this programmer. If you know, can you give me the format of the wave file(*.wav) and Sun au file(*.au). Thank you.

2. Shell Programming and Scripting

How to export table data to xml file?

Hi , I would like to get some suggestion from the experts. My requirement is to export oracle table data as an xml file. Any unix/linux tools, scripts available? Regards,

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

4. Shell Programming and Scripting

Help required in Splitting a xml file into multiple and appending it in another .xml file

HI All, I have to split a xml file into multiple xml files and append it in another .xml file. for example below is a sample xml and using shell script i have to split it into three xml files and append all the three xmls in a .xml file. Can some one help plz. eg: <?xml version="1.0"?>...

5. Shell Programming and Scripting

Comparing delta values of one xml file in other xml file

Hi All, I have two xml files. One is having below input <NameValuePair> <name>Daemon</name> <value>tcp:7474</value> </NameValuePair> <NameValuePair> <name>Network</name> <value></value> </NameValuePair> ...

6. Shell Programming and Scripting

XML to Table conversion

<title>00000888</title> <name>XYZ</name> <updated>2397-2323</updated> <content>Content</content> <summary>summary12</summary> <title>00000788</title> <name>ABC</name> <updated>99090-09</updated> <content>Content123</content> ...

7. Shell Programming and Scripting

Splitting a single xml file into multiple xml files

Hi, I'm having a xml file with multiple xml header. so i want to split the file into multiple files. Sample.xml consists multiple headers so how can we split these multiple headers into multiple files in unix. eg : <?xml version="1.0" encoding="UTF-8"?> <ml:individual...

8. Shell Programming and Scripting

Script to load XML file to Oracle table

Experts. I have created a oracle table as below. create table xml_tab ( File_No number , File_content Varchar2(2000), file_type xmltype ); Daily we are receiving many XML files as below. here is our sample xml file. File1 :

LEARN ABOUT DEBIAN

xml::element

XML::Element(3pm)					User Contributed Perl Documentation					 XML::Element(3pm)

NAME

       XML::Element - XML elements with the same interface as HTML::Element

SYNOPSIS

	 [See HTML::Element]

METHODS AND ATTRIBUTES

   delete_ignorable_whitespace
       TODO: test and document this: with no tagname set, assumes ALL all-whitespace nodes are ignorable!

   endtag
       Redirects to HTML::Element::endtag_XML

   starttag
       Redirects to HTML::Element::starttag_XML

DESCRIPTION

       This is just a subclass of HTML::Element.  It works basically the same as HTML::Element, except that tagnames and attribute names aren't
       forced to lowercase, as they are in HTML::Element.

       HTML::Element describes everything you can do with this class.

CAVEATS

       Has currently no handling of namespaces.

SEE ALSO

       XML::TreeBuilder for a class that actually builds XML::Element structures.

       HTML::Element for all documentation.

       XML::DOM and XML::Twig for other XML document tree interfaces.

       XML::Generator for more fun.

COPYRIGHT AND DISCLAIMERS

       Copyright (c) 2000,2004 Sean M. Burke.  All rights reserved.

       This library is free software; you can redistribute it and/or modify it under the same terms as Perl itself.

       This program is distributed in the hope that it will be useful, but without any warranty; without even the implied warranty of
       merchantability or fitness for a particular purpose.

AUTHOR

       Sean M. Burke, <sburke@cpan.org>

perl v5.10.1							    2011-03-05							 XML::Element(3pm)