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
chih chungSubject: XML formatting for data file
Author: chih chung
Date: 22 Mar 2006 05:44 PM
Originally Posted: 22 Mar 2006 05:42 PM
Dear All,<br> <br> I need to format the data file into well-formed XML file with the following requirement:<br> <br> before XML formatting<br> <br> type_of_ins="PIERS & DOCKS COVERAGE ON ASSURED'S LOCATION IN DUNEDIN, FL"<br> <br> after XML formatting: <br> <br> <type_of_ins>PIERS &amp; DOCKS COVERAGE ON ASSURED&apos; LOCATION IN DUNEDIN, FL</type_of_ins><br> <br> <br> I just wonder that stylus Studio 2006 XML editor or other tools might have capability to perform the above XML formatting. Please advise. I attach sample data file and expected XML output file for your reference. Thanks.<br> <br> Regards,<br> Chih Chung



Tony LavinioSubject: XML formatting for data file
Author: Tony Lavinio
Date: 30 Mar 2006 02:33 PM
I'm using Stylus Studio 2006 Release 2 XML Enterprise, which is
available here: http://www.stylusstudio.com/xml_download.html

This need to be done in two steps.
First, create a mapping that converts the sample.txt file into
XML. Second, use XSLT (or XQuery) to change that into the
exact structure you want for output.

First, do File|New|Convert to XML.
Choose your sample.txt file.
Change the following properties:
Delimiter Pairs from blank to '"','"'
Key=Value Character from blank to '='
Row Element Name from "row" to blank
Omit from Output from "Only when Empty" to "Never"

Use File|Save this as something like sample.conv.

Next, you can build your XSLT.
Choose File|New|XSLT: Mapper.

Click on "Add Source Document" and choose sample.txt.
Before clicking Open, put a check in the 'Use Adapter'
box and then choose sample.conv from the subsequent dialog.

Click on "Add Target Document" and choose a sample document
that matches the output you want - in your case,

Now, build your map, which will generate your XSLT.

When you finish, you should have what you want.

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!  

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.