01-12-2011
If you show us a reasonable example of your XML files, I can probably provide you a simple XSLT stylesheet that will generate a CSV file.
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
I'm trying to merge multiple CSV (comma separated value) files into one large master file. All files have a field that is unique to act as the key for entry/merging into the master file & and all files have the same number of fields that are in the master file.
I'll give an example here:
... (2 Replies)
Discussion started by: jjinca
2 Replies
2. Shell Programming and Scripting
Hi I am Newbie to Unix.Appreciate Help from forum
user would loada b.Csv File(Below example) in /data/m/ directory.Program need to read the b.csc to extract certain column and create a new file /data/d/ directory as csv file with new name.
User File Format
1232,samshouston,12345... (3 Replies)
Discussion started by: skywayterrace
3 Replies
3. Shell Programming and Scripting
Hi All
I am trying to create a csv file in the korn shell and the script segment is as follows:
if
then
# NEED TO ADD INFO TO THE EMAIL FILE ABOUT THE DRIVE THAT'S FILLING UP
echo "$drive $percent% $space "|\
awk '{printf("%d/t"|"%d/t"|"%d/t\n",... (6 Replies)
Discussion started by: Segwar
6 Replies
4. UNIX for Advanced & Expert Users
Hello,
I've been tasked with sending 3 types of data (file size, row count, and file name) to a csv file every month for various vendors. I have been asked to put this in one csv or xls file with each vendor being a different tab (or worksheet). Until now, we have been finding and emailing... (4 Replies)
Discussion started by: tekster757
4 Replies
5. UNIX for Dummies Questions & Answers
I have a requirement which will select the files with a specific naming convention which got created in past 7 days in a specific directory.Lets say the directory is /data/XYZ and the file names follow the below nomenclature like Daily_File*.txt
I just need to create one CSV file which will... (12 Replies)
Discussion started by: dr46014
12 Replies
6. Shell Programming and Scripting
I've googled a lot on this, but could not fine a simple one-liner to do this.
I have a .csv file that looks like this:
Header one
Header two
Header three
col1,col2,col3
short data, very long data, dataIf I use sed and change the comma to tab, being the colums of variable length I don't get a... (6 Replies)
Discussion started by: ahsog
6 Replies
7. UNIX for Dummies Questions & Answers
I have the following simplified script, that consists of a download (wget), a grab of only the lines with a comma (grep) and a rename of the file to indicate its date of origin (mv):
wget http://www.example.com/datafile.csv
grep ',' datafile.csv
mv datafile.csv datafile.`date... (2 Replies)
Discussion started by: figaro
2 Replies
8. UNIX for Dummies Questions & Answers
Hi Gurus,
I need your help in transforming the CSV file into some what a report format.
My source file looks like below
Date,ProdID,TimeID,LevelID
2010-08-31,200,M,1
2010-08-31,201,Q,2
2010-08-31,202,Y,1
2010-08-31,203,M,5
Output required is
... (9 Replies)
Discussion started by: naveen.kuppili
9 Replies
9. UNIX for Dummies Questions & Answers
Hi guys,
I am not experienced with Unix, so please dont mind if the question seem to be irrelevant.
I have written a simple script, that connects DB & fetches few records from a table. I wanted to get those details as file in .CSV format via mail.
-I stored the query o/p in a file.
-I... (6 Replies)
Discussion started by: sumitburnwal88
6 Replies
10. UNIX for Dummies Questions & Answers
I have a flat file that contains dynamic list of variables like
a=1
b=2
c=3
.
..
z=26
I need to convert the above into a csv file having the format below:
a,b,c,..,z
1,2,3,..,26
Please note, I do not want a comma separating the last variable.
I tried to refer the post... (4 Replies)
Discussion started by: vkumbhakarna
4 Replies
XALAN(1) General Commands Manual XALAN(1)
NAME
xalan - Process XML documents with XSLT stylesheets
SYNOPSIS
xalan [options]
DESCRIPTION
Xalan-C++ (named after a rare musical instrument) implements the W3C Recommendation 16 November 1999 XSL Transformations (XSLT) Version 1.0
and the XML Path Language (XPath) Version 1.0. XSLT is the first part of the XSL stylesheet language for XML. It includes the XSL Transfor-
mation vocabulary and XPath, a language for addressing parts of XML documents. For links to background materials, discussion groups, fre-
quently asked questions, and tutorials on XSLT, see Getting up to speed with XSLT.
You use the XSLT language to compose XSL stylesheets. An XSL stylesheet contains instructions for transforming XML documents from one docu-
ment type to another document type (XML, HTML, or other). In structural terms, an XSL stylesheet specifies the transformation of one tree
of nodes (the XML input) into another tree of nodes (the output or transformation result).
OPTIONS
Options are case-sensitive.
-in URL
Sets the input URL. If nothing is set, stdin is used.
-xsl URL
Sets the XSLT sheet URL.
-out file
Sets the output filename.
-v Show version information only.
-qc Quiet pattern conflicts warnings.
-q Use quiet mode.
-indent n
Controls how many spaces to indent. Default is 0.
-validate
Controls whether validation occurs. Validation is off by default.
-tt Trace the templates as they are being called.
-tg Trace each generation event.
-ts Trace each selection event.
-ttc Trace the template children as they are being processed.
-xml Use XML formatter and add XML header.
-text Use simple Text formatter.
-html Use HTML formatter.
-dom Use DOM formatter. Formats to DOM, then formats XML for output.
-xst Use source tree formatter. Formats to Xalan source tree, then formats XML for output.
-param name expression
Sets a stylesheet parameter.
-xd Use Xerces DOM instead of Xalan source tree.
-de Disable built-in extension functions
The following option is valid only with -HTML
-noindent
Turn off HTML indenting.
The following option is valid only with -XML.
-nh Don't write XML header.
AUTHOR
The Apache Software Foundation.
SEE ALSO
http://www.w3.org/TR/xslt
XSL Transformations Version 1.0 (XSLT)
http://www.w3.org/TR/xpath
XML Path Language Version 1.0 (XPATH)
Debian GNU/Linux 2001 XALAN(1)