Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Parse XML file into CSV with shell?
Top Forums Shell Programming and Scripting Parse XML file into CSV with shell? Post 302262136 by fpmurphy on Wednesday 26th of November 2008 12:06:20 PM
Old 11-26-2008
Here is an example of how to do it using xsltproc. Suppose your XML document (file.xml) contains 2 records i.e.
Code:
<?xml version = "1.0"?>
<root>
<eq action="A" sectyType="0" symbol="PGR" exch="CA" curr="VEF" sess="NORM" dfltInd="1" issuerName="PROAGROI-7 B" issuSho
rtDesc="VEB100" sectySubType="" sedol="2705132" isin="VEV000901000" cusip="" localCode="VEV000901000" localId="5" Csymbo
l="PGR" Cexch="CA" Ccurr="VEF" Csess="NORM" Psymbol="PGR" Pexch="CA" Pcurr="VEF" Psess="NORM" Ssymbol="PGR" Sexch="CA" S
curr="VEF" Ssess="NORM" exclPFInd="0" ranking="" longIssuerName="PROAGRO, C.A." issuLongDesc="VEB100" sicCode="" exchSym
="" streetSym="" mostLiquid="0" />
<eq action="A" sectyType="0" symbol="PGR" exch="BB" curr="VEF" sess="NORM" dfltInd="1" issuerName="PROAGROI-8 B" issuSho
rtDesc="VEB100" sectySubType="" sedol="2705132" isin="VEV000901000" cusip="" localCode="VEV000901000" localId="5" Csymbo
l="PGR" Cexch="CA" Ccurr="VEF" Csess="NORM" Psymbol="PGR" Pexch="CA" Pcurr="VEF" Psess="NORM" Ssymbol="PGR" Sexch="CA" S
curr="VEF" Ssess="NORM" exclPFInd="0" ranking="" longIssuerName="PROAGRO, C.A." issuLongDesc="VEB100" sicCode="" exchSym
="" streetSym="" mostLiquid="0" />
</root>

and you have an XSL stylesheet called file.xsl (deliberately simplified) which contains
Code:
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<xsl:output method="text"/>

<xsl:template match="/">
  <xsl:apply-templates select="/root/eq"/>
</xsl:template>

<!-- write out comma separated file -->
<xsl:template match="/root/eq">
   <xsl:value-of select="@issuerName"/>
   <xsl:value-of select="','"/>
   <xsl:value-of select="@symbol"/>
   <xsl:value-of select="','"/>
   <xsl:value-of select="@exch"/>
   <xsl:value-of select="','"/>
   <xsl:value-of select="@curr"/>
   <xsl:value-of select="','"/>
   <xsl:value-of select="@Csymbol"/>
   <xsl:value-of select="','"/>
   <xsl:value-of select="@Cexch"/>
   <xsl:value-of select="','"/>
   <xsl:value-of select="@Ccurr"/>
   <xsl:text>
</xsl:text>
</xsl:template>

</xsl:stylesheet>

Using xsltproc to transform the document produces the required output
Code:
$ xsltproc file.xsl file.xml
PROAGROI-7 B,PGR,CA,VEF,PGR,CA,VEF
PROAGROI-8 B,PGR,BB,VEF,PGR,CA,VEF

 

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

Parse a string in XML file using shell script

Hi! I'm just new here and don't know much about shell scripting. I just want to ask for help in creating a shell script that will parse a string or value of the status in the xml file. Please sample xml file below. Can you please help me create a simple script to get the value of status? Also it... (46 Replies)
Discussion started by: ayhanne
46 Replies

3. Shell Programming and Scripting

regex/shell script to Parse through XML Records

Hi All, I have been working on something that doesn't seem to have a clear regex solution and I just wanted to run it by everyone to see if I could get some insight into the method of solving this problem. I have a flat text file that contains billing records for users, however the records... (5 Replies)
Discussion started by: Jerrad
5 Replies

4. Shell Programming and Scripting

Parse XML file in shell script

Hi Everybody, I have an XML file containing some data and i want to extract it, but the specific issue in my file is that the data is repeated some times like the following example : <section1> <subsection1> X=... Y=... Z=... <\subsection1> <subsection2> X=... Y=... Z=...... (2 Replies)
Discussion started by: yassine
2 Replies

5. Shell Programming and Scripting

Korn shell program to parse CSV text file and insert values into Oracle database

Enclosed is comma separated text file. I need to write a korn shell program that will parse the text file and insert the values into Oracle database. I need to write the korn shell program on Red Hat Enterprise Linux server. Oracle database is 10g. (15 Replies)
Discussion started by: shellguy
15 Replies

6. 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... (8 Replies)
Discussion started by: jackma
8 Replies

7. UNIX for Dummies Questions & Answers

Help to parse csv file with shell script

Hello ! I am very aware that this is not the first time this question is asked here, because I have already read a lot of previous answers, but none of them worked, so... As said in the title, I want to read a csv file with a bash script. Here is a sample of the file: ... (4 Replies)
Discussion started by: Grhyll
4 Replies

8. Shell Programming and Scripting

BASH script to parse XML and generate CSV

Hi All, Hope all you are doing good! Need your help. I have an XML file which needs to be converted CSV file. I am not an expert of awk/sed so your help is highly appreciated!! XML file looks like this: <l:event dateTime="2013-03-13 07:15:54.713" layerName="OSB" processName="ABC"... (2 Replies)
Discussion started by: bhaskar_m
2 Replies

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

10. 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"/> ... (5 Replies)
Discussion started by: Zam_1234
5 Replies

LEARN ABOUT OPENSOLARIS

iscsitgtd

iscsitgtd(1M)						  System Administration Commands					     iscsitgtd(1M)

NAME

       iscsitgtd - iSCSI Target daemon

SYNOPSIS

       iscsitgtd [-d door_file]

DESCRIPTION

       The  iscsitgtd  daemon  process	implements  the  iSCSI configuration,  control, and data paths, providing iSCSI Target Mode support in the
       Solaris operating system.

       The configuration and control path is by means of the Solaris Doors  subsystem (see door_create(3C)), and provides  the	interface  between
       the   iSCSI Target administration utility, iscsitadm(1M), persistence configuration data stored in the Service Configuration Facility (SCF)
       of the service  management facility (SMF). See smf(5).

       The data path managed by the daemon exists between TPC/IP port 3260, and the files, block devices, or raw SCSI devices configured as  iSCSI
       target LUNs.

OPTIONS

       The following options is supported:

       -d door_file

	   Override the location of the Solaris Door used for configuration from /var/run/iscsi_tgt_door to a door of one's choosing.

   Solaris Configuration Facility (SCF)
       The following options are supported:

       PGR-basedir

	   SCSI-3 PGR base directory for ZVOL failover. Set to /.

       daemonize

	   Run as Solaris daemon process. Either true or false.

       dbg-lvl

	   Runtime debug level to console.

       qlog-lvl

	   Runtime logging to /tmp/target_log.

       The following are the logging values, in hexadecimal.

	 0x00001 - Connection errors
	 0x00002 - Connection login errors
	 0x00004 - Connection Non-I/O errors
	 0x00008 - Connection I/O errors
	 0x00010 - Session errors
	 0x00020 - Session login errors
	 0x00040 - Session Non-I/O errors
	 0x00080 - Session I/O errors
	 0x00100 - Emulation errors
	 0x00200 - Emulation Non-I/O errors
	 0x00400 - Emulation I/O errors
	 0x01000 - General errors
	 0x02000 - General details
	 0x04000 - iSNS details
	 0x10000 - SCSI-3 PGR errors
	 0x20000 - SCSI-3 PGR Non-I/O errors
	 0x40000 - SCSI-3 PGR I/O errors

EXAMPLES

       Example 1 Listing All iscsitgt Values

       The following commands lists all iscsitgt values.

	 # svccfg -s iscsitgt listprop iscsitgt

       Example 2 Setting SCF Options

       The following command sets the PGR-basedir option.

	 # svccfg -s iscsitgt setprop iscsitgt/PGR-basedir = astring: "/"

       The following command sets the dbg-lvl option.

	 # svccfg -s iscsitgt setprop iscsitgt/dbg-lvl = integer: 0x80ffffff

ATTRIBUTES

       See attributes(5) for descriptions of the following attributes:

       +-----------------------------+-----------------------------+
       |      ATTRIBUTE TYPE	     |	    ATTRIBUTE VALUE	   |
       +-----------------------------+-----------------------------+
       |Availability		     |SUNWiscsitgtu		   |
       +-----------------------------+-----------------------------+
       |Interface Stability	     |Volatile			   |
       +-----------------------------+-----------------------------+

SEE ALSO

       iscsitadm(1M), door_create(3C), attributes(5), smf(5)

NOTES

       The iSCSI Target daemon, iscsitgtd, is managed by the service management facility, smf(5), under the fault management resource identifier:

	 svc:/system/iscsitgt:default

SunOS 5.11							    16 Mar 2009 						     iscsitgtd(1M)
All times are GMT -4. The time now is 04:50 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy