XML Editor
Sign up for a WebBoard account Sign Up Keyword Search Search More Options... Options
Chat Rooms Chat Help Help News News Log in to WebBoard Log in Not Logged in
Show tree view Topic
Topic Page 1 2 3 4 5 6 7 8 9 Go to previous topicPrev TopicGo to next topicNext Topic
Postnext
Ryan JohnsonSubject: XML to fixed length text
Author: Ryan Johnson
Date: 02 May 2005 04:31 PM
I am new to this product because I am searching for a solution that will take my XML file and create a fixed length text file.

How do I go about doing this? I am very new to XML but learning quick.

Thanks,

Ryan Johnson

Postnext
Ivan PedruzziSubject: XML to fixed length text
Author: Ivan Pedruzzi
Date: 02 May 2005 06:52 PM
Assume to have the following XML input document created with built-in CSV adapter
(adapter:CSV:newline=crlf:sep=,:first=no:escape=\:quotes='"?file:///c:/Program Files/Stylus Studio XML Professional Edition/examples/Adapters/one.csv)


<?xml version="1.0" encoding="ISO-8859-1"?>
<table>
<row>
<column.1>make</column.1>
<column.2>model</column.2>
<column.3>year</column.3>
<column.4>mileage</column.4>
</row>
<row>
<column.1>BMW</column.1>
<column.2>R1150RS</column.2>
<column.3>2004</column.3>
<column.4>14274</column.4>
</row>
<row>
<column.1>Kawasaki</column.1>
<column.2>GPz1100</column.2>
<column.3>1996</column.3>
<column.4>60234</column.4>
</row>
<row>
<column.1>Ducati</column.1>
<column.2>ST2</column.2>
<column.3>1997</column.3>
<column.4>24000</column.4>
</row>
<row>
<column.1>Moto Guzzi</column.1>
<column.2>LeMans</column.2>
<column.3>2001</column.3>
<column.4>12393</column.4>
</row>
<row>
<column.1>BMW</column.1>
<column.2>R1150R</column.2>
<column.3>2002</column.3>
<column.4>17439</column.4>
</row>
<row>
<column.1>Ducati</column.1>
<column.2>Monster</column.2>
<column.3>2000</column.3>
<column.4>15682</column.4>
</row>
<row>
<column.1>Aprilia</column.1>
<column.2>Futura</column.2>
<column.3>2001</column.3>
<column.4>17320</column.4>
</row>
</table>

With the following XSLT you get back CSV

<?xml version='1.0'?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<xsl:output method="text"/>

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

<xsl:template match="text()"/>

<xsl:template match="row">
<xsl:apply-templates/>
<xsl:text>
</xsl:text>
</xsl:template>

<xsl:template match="column.1|column.2|column.3">
<xsl:value-of select="."/>
<xsl:text>,</xsl:text>
</xsl:template>

<xsl:template match="column.4">
<xsl:value-of select="."/>
</xsl:template>

</xsl:stylesheet>




Posttop
Tony LavinioSubject: XML to fixed length text
Author: Tony Lavinio
Date: 03 May 2005 08:57 AM
An example of producing fixed-width fields from XML input is on
another forum on SSDN. Please see
http://www.stylusstudio.com/SSDN/default.asp?action=9&read=3179&fid=47

 
Topic Page 1 2 3 4 5 6 7 8 9 Go to previous topicPrev TopicGo to next topicNext Topic
Download A Free Trial of Stylus Studio 6 XML Professional Edition Today! Powered by Stylus Studio, the world's leading XML IDE for XML, XSLT, XQuery, XML Schema, DTD, XPath, WSDL, XHTML, SQL/XML, and XML Mapping!  
go

Log In Options

Site Map | Privacy Policy | Terms of Use | Trademarks
Stylus Scoop XML Newsletter:
W3C Member
Stylus Studio® and DataDirect XQuery ™are from DataDirect Technologies, is a registered trademark of Progress Software Corporation, in the U.S. and other countries. © 2004-2016 All Rights Reserved.