Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: XML to Table conversion
Top Forums Shell Programming and Scripting XML to Table conversion Post 302951524 by RudiC on Friday 7th of August 2015 05:30:36 AM
Old 08-07-2015
Well, I don't think those "asdf" should be taken literally. For any space separated text as the respective field contents, try
Code:
awk -v HD="title name updated content summary" '
BEGIN           {for (N=i=split (HD, T); i>0; i--) SRCH[T[i]]
                 for (i=1; i<=N; i++) printf "%s\t", T[i]
                 print ""
                }
                {TMP=$0
                 gsub (/<|>.*$/, "", TMP)
                }
L &&
TMP == T[1]     {for (i=1; i<=N; i++) printf "%s\t", PR[T[i]]
                 print ""
                 delete PR
                }

TMP in SRCH     {gsub (/<[^>]*>/, "")
                 PR[TMP]=$0
                 L=1
                }
END             {for (i=1; i<=N; i++) printf "%s\t", PR[T[i]]
                 print ""
                }

' file

---------- Post updated at 11:30 ---------- Previous update was at 11:29 ----------

Unfortunately you changed horses (OFS) between your post#1 and #3; adapt the script accordingly.
 

10 More Discussions You Might Find Interesting

1. UNIX for Advanced & Expert Users

About XML file Integrating to a table

Hi , I have a question about unix shell scripting. I hope someone may help me to solve problem. In our system , there are two server that generate two different log file which are XML format in UNIX system. The problem is , this XML files contain such counter names and values sometimes this... (1 Reply)
Discussion started by: kbiricik
1 Replies

2. Shell Programming and Scripting

select values from db1 table and insert into table of DB2

Hi I am having three oracle databases running in three different machine. their ip address is different. from one of the DB am able to access both the databases.(means am able to select values and insert values in to tables individually.) I need to fetch some data from DB1 table(say DB1 ip is... (2 Replies)
Discussion started by: aemunathan
2 Replies

3. 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, (2 Replies)
Discussion started by: LinuxLearner
2 Replies

4. Shell Programming and Scripting

Text to XML conversion using script

Hi I have a file in the format with so many records DB2 Universal JDBC Driver Provider,wdialdcsq,New JDBC Datasource,jdbc/wdialdcsq,,dcsqdb2n,cldrdgw1.is.chrysler.com,2998,DB2,10,1,180,0,1800 i need to convert all these into <DataSource name="wdialODDC" maxConnection="10" minConnection="0 "... (1 Reply)
Discussion started by: mskalyani9
1 Replies

5. Shell Programming and Scripting

Adding a field to a file using a conversion table

Hello everyone, Here is what i am trying to accomplish. I have a transaction log that I want to to add a field. The fields in the transaction log are tab delimited FYI. My goal is to add a column specifying the category/type to each item purchased. I have created a two column "conversion table"... (2 Replies)
Discussion started by: SpencerClark
2 Replies

6. UNIX for Dummies Questions & Answers

Find & Replace identifiers using a conversion table

Hi ! I have input.tab with one column containing Item IDs under a number format (the second column is the Location of this item): Location Item ID rack1 12; 35; 43 rack35 23; 894; 5478; 98 etc... (The number of Items per row is variable. Item IDs in a same field are... (17 Replies)
Discussion started by: lucasvs
17 Replies

7. Shell Programming and Scripting

Build a table from a list by comparing existing table entries

I am new to this shell scripting.... I have a file which contains list of users. This files get updated when new user comes into the system. I want to create script which will give a table containing unique list of users. When I say unique, it means script should match table while parsing... (3 Replies)
Discussion started by: dchavan1901
3 Replies

8. UNIX for Beginners Questions & Answers

Replacing string/special characters using a 'conversion' table

Hi, Does anyone know if there is a script or program available out there that uses a conversion table to replace special characters from a file? I am trying to remove some special characters from a file but there are several unprintable/control characters that some I need to remove but some I... (2 Replies)
Discussion started by: newbie_01
2 Replies

9. 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 : (7 Replies)
Discussion started by: vasuvv
7 Replies

10. Web Development

Getting Rid of Annoying Bootstrap Table Borders and Wayward Table Lines

Bootstrap is great; but we have had some issues with Bootstrapped <tables> (and legacy <fieldset> elements) showing annoying, wayward lines. I solved that problem today with this simple jQuery in the footer: <script> $(function(){ $('tr, td, fieldset,... (0 Replies)
Discussion started by: Neo
0 Replies

LEARN ABOUT DEBIAN

xml::easy::transform

XML::Easy::Transform(3pm)				User Contributed Perl Documentation				 XML::Easy::Transform(3pm)

NAME

       XML::Easy::Tranform - XML processing with a clean interface

DESCRIPTION

       The "XML::Easy::Transform::" namespace exists to contain modules that perform transformations on XML documents, or parts thereof, in the
       form of XML::Easy::Element and XML::Easy::Content nodes.

       XML::Easy is a collection of modules relating to the processing of XML data.  It includes functions to parse and serialise the standard
       textual form of XML.  When XML data is not in text form, XML::Easy processes it in an abstract syntax-neutral form, as a collection of
       linked Perl objects.  This in-program data format shields XML users from the infelicities of XML syntax.  Modules under the
       "XML::Easy::Transform::" namespace operate on XML data in this abstract structured form, not on textual XML.

       A transformation on XML data should normally be presented in the form of a function, which takes an XML::Easy::Element node as its main
       parameter, and returns an XML::Easy::Element node (or "die"s on error).	The input node and output node each represent the root element of
       the XML document (or fragment thereof) being transformed.  These nodes, of course, contain subordinate nodes, according to the structure of
       the XML data.  A reference to the top node is all that is required to effectively pass the whole document.

OTHER DISTRIBUTIONS

       CPAN distributions under this namespace are:

       XML::Easy::Transform::RationalizeNamespacePrefixes
	   Manages XML Namespaces by hoisting all namespace declarations to the root of a document.

SEE ALSO

       XML::Easy

AUTHOR

       Andrew Main (Zefram) <zefram@fysh.org>

COPYRIGHT

       Copyright (C) 2009, 2010, 2011 Andrew Main (Zefram) <zefram@fysh.org>

LICENSE

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

perl v5.14.2							    2011-11-16						 XML::Easy::Transform(3pm)
All times are GMT -4. The time now is 10:46 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy