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 10 11 12 13 14 15 16 17 18 19 20 Go to previous topicPrev TopicGo to next topicNext Topic
Postnext
Praveen PaletySubject: Fixed Length Record Layout to XML
Author: Praveen Palety
Date: 20 Jun 2010 11:15 AM
I am working with a a file similar to what was used in this example.
http://www.stylusstudio.com/varying_record_layout.html
Ony diffrence is ours is a fixed length file.
I have created a conversion file to convert input file to XML similar to below example.

<root>
<Region1>
<RecType2>...</RecType2>
<RecType3><Amt>..</Amt></RecType3>
<RecType4>...</RecType4>
<RecType5>...</RecType5>
<RecType6><Pay>..</Pay></RecType6>
<RecType2>...</RecType2>
<RecType3><Amt>..</Amt></RecType3>
<RecType4>...</RecType4>
<RecType5>...</RecType5>
<RecType6><Pay>..</Pay></RecType6>
<RecType2>...</RecType2>
<RecType3>><Amt>..</Amt></RecType3>
<RecType4>...</RecType4>
<RecType5>...</RecType5>
<RecType6><Pay>..</Pay></RecType6>
</Region1></root>

I have to create an XSLT to transform this XML to a new XML with each record set under its own node. Final XML should be similar to below. I am only interested in RecType3 and RecType6.

<Region1> <Payment><Amt>RecType3/Amt</Amt><Payee>RexType6/Pay</Payee></payment> <Payment><Amt>RecType3/Amt</Amt><Payee>RexType6/Pay</Payee></payment>
<Payment><Amt>RecType3/Amt</Amt><Payee>RexType6/Pay</Payee> </payment>
</Region1>

How can I do this? Is it easier to change the conv file to create separate nodes or write the logic in XSLT used for transformation?


Thanks,
Praveen
Travelex

Posttop
Rory FarrellSubject: Fixed Length Record Layout to XML
Author: Rory Farrell
Date: 06 Jul 2010 02:45 PM
Hi Praveen,

If the XSLT is still necessary to do other transformations then my preference would be to write the logic in XSLT rather than change the conv file.

Regards,
Rory

 
Topic Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 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.