Extract data from an XML file & write into a CSV file Post: 302413966

Sponsored Content

Top Forums Shell Programming and Scripting Extract data from an XML file & write into a CSV file Post 302413966 by durden_tyler on Sunday 18th of April 2010 09:21:18 PM

04-18-2010

Registered User

Code:

$
$
$ cat -n f0.xml
     1  <detail sim_ser_no_1="898407109001000090"
     2  imsi_1="452070001000090">
     3  <security>ADM1[1]=????</security>
     4  <security>PIN1[1]=????</security>
     5  <security>PIN2[1]=????</security>
     6  <security>PUK1[1]=????</security>
     7  <security>PUK2[1]=????</security>
     8  </detail>
     9  <detail sim_ser_no_1="898407109001000091"
    10  imsi_1="452070001000091">
    11  <security>ADM1[1]=????</security>
    12  <security>PIN1[1]=????</security>
    13  <security>PIN2[1]=????</security>
    14  <security>PUK1[1]=????</security>
    15  <security>PUK2[1]=????</security>
    16  </detail>
$
$ perl -ne 'if (/^<detail.*="(\d+)/) {print $1}
            elsif (/imsi_1="(\d+)/) {print ",$1"}
            elsif (/<security.*=(.*?)</) {print ",$1"}
            else {print "\n"}' f0.xml
898407109001000090,452070001000090,????,????,????,????,????
898407109001000091,452070001000091,????,????,????,????,????
$
$

tyler_durden

durden_tyler

View Public Profile for durden_tyler

Find all posts by durden_tyler

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Extract string from a file & write to a new file (Perl)

Hi, This is the first time playing around with perl and need some help. Assuming if i have a line of text that looks like this: Date/Time=Nov 18 17:12:11;Device Name=192.168.1.1;Device IP=192.168.1.1;Device Class=IDS;Source IP=155.212.212.111;Source Name=UNKNOWN;Source Port=1679...

2. Shell Programming and Scripting

Data Extract from XML Log File

3. Shell Programming and Scripting

How to extract data from csv file

Hello everybody, Here is my problem, I don't know anything about shell programming and my boss is actually asking me to develop a shell script in order to get values in a csv file from a specific date. Here is a sample of the csv file : Date;Encha�nement;Titre;Libell� ;calendrier;Heure d�but;Heure...

4. Shell Programming and Scripting

Perl extract number from file & write to file

I have 1 file that has elements as follows. Also the CVR(10) and the word "SAUCE" only appear once in the file so maybe a grep command would work? file1 CVR( 9) = 0.385E+05, ! VEHICLE CVR(10) = 0.246E+05, ! SAUCE CVR(11) = 0.162E+03, ! VEHICLE I need to extract the...

5. Shell Programming and Scripting

Extract and parse XML data (statistic value) to csv

Hi All, I need to parse some statistic data from the "measInfo" -eg. 25250000 (as highlighted) and return the result into line by line, and erasing all other unnecessary info/tag. Thought of starting with grep "measInfoID="25250000" but this only returns 1 line. How do I get all the output...

6. Shell Programming and Scripting

Extract data from XML file

Hi , I have input file as XML. following are input data #complex.xml <?xml version="1.0" encoding="UTF-8"?> <TEST_doc xmlns="http://www.w3.org/2001/XMLSchema-instance"> <ENTRY uid="123456"> <protein> <name>PROT001</name> <organism>Human</organism> ...

7. Shell Programming and Scripting

Extract data from XML file and write in CSV file

Hi friend i have input as following XML file <?xml version="1.0"?> <Document xmlns="urn:iso:std:iso:20022:tech:xsd:camt.054.001.02"> <BkToCstmrDbtCdtNtfctn> <GrpHdr><MsgId>LBP-RDJ-TE000000-130042430010001001</MsgId><CreDtTm>2013-01-04T03:21:30</CreDtTm></GrpHdr>...

8. Shell Programming and Scripting

How to extract data from xml file using shell scripting?

Hi evry1, This is my 1st post in this forum.Pls help me I want to extract some data froma xml file which has 2000 lines using shell scripting. Actually my xml file has some "audio and video codes" which i need to arrange in a column wise format after extracting it using shell scripting.I...

9. Shell Programming and Scripting

Pass some data from csv to xml file using shell/python

Hello gurus, I have a csv file with bunch of datas in each column. (see attached) Now I have an .xml file in the structure of below: ?xml version="1.0" ?> <component id="root" name="root"> <component id="system" name="system"> <param name="number_of_A" value="8"/> ...

10. Shell Programming and Scripting

Extract Data from XML file.

Hi Guys, I am in a need to extract data from a xml file. The XML file format is as below. <data jsxnamespace="propsbundle" locales=""> <locale>  <record jsxid="CHARPAIR001" jsxtext=" must be selected"></record> <record...

LEARN ABOUT DEBIAN

cgi::xml

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

NAME

       CGI::XML - Perl extension for converting CGI.pm variables to/from XML

SYNOPSIS

	 use CGI::XML;
	 $q = new CGI::XML;

	 # convert CGI.pm variables to XML
	 $xml = $q->toXML;
	 $xml = $q->toXML($root);

	 # convert XML to CGI.pm variables
	 $q->toCGI($xml);

DESCRIPTION

       The CGI::XML module converts CGI.pm variables to XML and vice versa.

       CGI::XML is a subclass of CGI.pm, so it reads the CGI variables just as CGI.pm would.

METHODS

       $q = new CGI::XML
	   creates a new instance of CGI::XML. You also have access to all of the methods in CGI.pm.

       $q->toXML([$root])
	   where $root is an optional parameter that specifies the root element. By default, toXML will not return a root element.

       $q->toCGI($xml)
	   where $xml is the XML you would like to convert to CGI.pm parameters. Values in the XML will overwrite any existing values if they
	   exist.

NOTE

       CGI::XML does not currently handle multiple selections passed from HTML forms. This will be added in a future release.

AUTHOR

       Jonathan Eisenzopf <eisen@pobox.com>

CONTRIBUTORS

       David Black <dblack@candle.superlink.net>

SEE ALSO

       perl(1), XML::Parser(3).

perl v5.8.8							    2004-12-05								  XML(3pm)