XML Editor
Sign up for a WebBoard account Sign Up Keyword Search Search More Options... Options
search
Chat Rooms Chat Help Help News News Log in to WebBoard Log in Not Logged in
Home » Boards » Stylus Studio Developer Network » Stylus Studio Technical Forum » fixed-width to XML
Conferences Close Tree View
+ Stylus Studio Feature Requests (1192)
- Stylus Studio Technical Forum (14621)
-> + JVM detection not finding JDK ... (2)
-> - stylus studio version 2011 pro... (1)
-> - WSDL 2.0 (1)
-> + Special characters in xml (2)
-> + cannot connect to mysql commun... (2)
-> + create a report from an existi... (2)
-> + Content not allowed in prolog (2)
-> + DB IInformix with database loc... (8)
-> + Stylus Report Designer (XML Re... (4)
-> - error: cos-nonambig: Content m... (1)
-> - UNIX .csv conversion and java ... (1)
-> + Nillable element, Validation e... (2)
-> + EDI Converter Error (2)
-> - CSV FILE INTO CARGO-IMP MESSAG... (1)
-> + BUG: Validation in piple will ... (2)
-> + Is there a 64-Bit Stylus Studi... (2)
-> + BUG: Read structure on SQL Ser... (3)
-> + [Customer Toyoto Motors Europe... (2)
-> - Get a schema for a JSON file (1)
-> + UNOC:4 forces converter to inp... (2)
-> - java class for xs:any elements (1)
-> + changing component separator (3)
-> + Output view disappeared (6)
-> + How to convert deeply nested X... (2)
-> + javax.net.ssl.SSLException (4)
-> + error converting .csv in a uni... (10)
-> + Menu bar disappeared (3)
-> - No Topic (1)
-> - What does "XML" stand for? So... (1)
-> - So XML is just HTML on steroid... (1)
-> + XHTML to XML conversion (2)
-> - Stylus Studio with DDTek xml c... (1)
-> + Installation fails (3)
-> + Is there a keyboard shortcut t... (2)
-> - Bug: Adding a scenario to an X... (1)
-> - Bug: Bug reporting outputs an ... (1)
-> - Tradacoms Invoice 9 Batch Quer... (1)
-> - problem with the product regis... (1)
-> + Help: Documentation... ends in... (2)
-> + How to install LIBxml2 (2)
-> - line numbers in validator outp... (1)
-> + Sharing Viollation in Stylus v... (5)
-> - support for asp.net in stylus... (1)
-> + how to use the latest java xml... (2)
-> - how to show xsd element relate... (1)
-> - Testing Stylus in a secure env... (1)
-> + How do you remove linemarkings... (3)
-> - Bug: Comment / Uncomment via C... (1)
-> + Setting escape (release) chara... (2)
-> + Xalan processor not showing up (2)
-> + Is there a keyboard shortcut t... (3)
-> - Modifying reports outside of S... (1)
-> + Run ALL Scenarios? (2)
-> + predefined macros ${ (4)
-> - TRADACOMS - EDI (1)
-> + SUM not working (3)
-> - Large xml file handling gives ... (1)
-> + 2011 Enterprise code folding f... (9)
-> + custom xml converter (3)
-> - Start Excel feter the mapping ... (1)
-> + Uninstall (2)
-> + xpath to compare two values fr... (2)
-> - xpath to compare two values fr... (1)
-> + SS2011 cannot save XML files u... (3)
-> + SS 2011 Enterprise saying 2010... (2)
-> + How to change the way whitespa... (7)
-> + Updating Relational Data Using... (4)
-> - Contract Stylus Studio help. ... (1)
-> + UTF_8 characters not displayed (6)
-> + Problem XSL to PDF ( dont reco... (2)
-> + HIPAA EDI - Looping question (4)
-> - HIPAA EDI - Looping question (1)
-> + Does XML Report support column... (2)
-> + Limited choice of XSL elements... (2)
-> + Single Source Publishing? (3)
-> - Stylus Stodio License (1)
-> - Stylus Stodio License (1)
-> + relax ng (3)
-> + having problem converting csv ... (8)
-> + error when selecting items fro... (2)
-> + CSV File to XML (3)
-> + Software registration - How to... (4)
-> - Software registration - How to... (1)
-> + .Net Saxon not supported by th... (2)
-> + How do I extend the Evaluation... (2)
-> + dst file (4)
-> + Flat File Custom XML conversio... (4)
-> + converting ascii file to xml f... (2)
-> + Evaluation Copy of Stylus Stud... (8)
-> + Batch process for soap (4)
-> + Strange error when running gen... (5)
-> + Merge Files (2)
-> + Convert cvs to XML (2)
-> + Stylus studio 2010 crashes in ... (5)
-> + excel to text (2)
-> + licence key? (2)
-> + JVM Heap error (4)
-> + How Do I clean TXT File? (2)
-> + SS Web Service Call Tester Pay... (3)
-> - SS Web Service Call Tester Mic... (1)
-- Previous [421-440] [441-460] [461-480] Next
+ Website Feedback (249)
+ XSLT Help and Discussion (7625)
+ XQuery Help and Discussion (2017)
+ Stylus Studio FAQs (159)
+ Stylus Studio Code Samples & Utilities (364)
+ Stylus Studio Announcements (113)
Topic  
Postnext
Tarek TarekSubject: fixed-width to XML
Author: Tarek Tarek
Date: 24 May 2005 10:59 AM
hi all,

i have a fixed-width textfile and i want to convert it to XML..
I have tried this with simple files where all the rows are the same and it works fine...

but now i have a textfile with diferent rows... so a parent row can have it's childs... but it is still a fixed-size file and not comma or anything else delimited...

for example:

#PARENT1 46890210
#CHILD12 E22 Q
#PARENT1 46890196
#CHILD12 E22 R
#PARENT1 46890179
#CHILD12 E22 R
#PARENT1 46890167
#CHILD12 E22 A
#PARENT1 46890150
#CHILD12 114 B
#PARENT1 46890108
#CHILD12 E22 R
Postnext
Tony LavinioSubject: fixed-width to XML
Author: Tony Lavinio
Date: 24 May 2005 03:00 PM
In Convert-to-XML, you can have a different set of fields for each
row that matches a specific pattern.

For your example, you can have rows that match "#PARENT1" output one
set of XML elements, and those that match "#CHILD12" output another
set.

See the "Add Node and Pattern" option, which comes up when you
right-click on a row. It will pre-fill with a best guess at what
you are trying to match.

There is more information on using this feature in the on-line
documentation at
http://www.stylusstudio.com/docs/v62/d_flatfileconversion8.html#wp457979

Postnext
Tarek TarekSubject: fixed-width to XML
Author: Tarek Tarek
Date: 25 May 2005 05:23 AM
the problem is... in fixed width mode, i can not define diffrent fixed/width settings per row-type...

in my example, in can't define diffrent row types for the #Parent1 and the #Child1..

and when i use the row-orietented-mode, i can't find any way to define my column.. because there is no delimiter between my columns..
Postnext
Tony LavinioSubject: fixed-width to XML
Author: Tony Lavinio
Date: 25 May 2005 08:13 AM
Ah. Yes, currently that is true. It is on the to-do list, but
we don't have a date for that at this time.

If your sample file looked like the one above, you might be able
to use the line mode, and use '#' as the line ending, and ' ' as
the field separator.
Postnext
Tarek TarekSubject: fixed-width to XML
Author: Tarek Tarek
Date: 25 May 2005 11:08 AM
oh. hope really that this will be avaible soon.

and about the ' ' seperator, I can't use it.. because in between some columns, i don't have seperators or empty space...

but still thanks for the fast reply and excelent service!
Postnext
Tarek TarekSubject: fixed-width to XML
Author: Tarek Tarek
Date: 27 Jun 2005 06:47 AM
does the new Release 3 support this feature ?
Postnext
Tarek TarekSubject: fixed-width to XML
Author: Tarek Tarek
Date: 27 Jun 2005 06:48 AM
does the new Release 3 support this feature ?
Postnext
(Deleted User) Subject: fixed-width to XML
Author: (Deleted User)
Date: 27 Jun 2005 09:05 AM
Hi, Tarek. Yes, Stylus Studio 6 Release 3 Professional Edition and Enterprise Edition both include the Convert to XML feature, which supports conversion of fixed-width files (and many other formats, like EDI and CSV) to XML. All versions of Stylus Studio provide a Fixed-Width to XML Document Wizard.

You can learn more about using the Convert to XML feature in

-- our video demonstrations, here:
http://www.stylusstudio.com/learn_convert_to_xml.html#converttoxml

-- the on-line documentation, here:
http://www.stylusstudio.com/docs/v62/d_flatfileconversion8.html#wp457979

The Fixed-Width to XML Document Wizard is described here:
http://www.stylusstudio.com/docs/v62/d_edit3.html#wp357658

Finally, searching SSDN and reading the Stylus Studio Web site can provide useful information for queries like this.

Hope this helps!

David Foster
Stylus Studio documentation

Postnext
Tarek TarekSubject: fixed-width to XML
Author: Tarek Tarek
Date: 29 Jun 2005 04:35 AM
but does support childs rows ??

--- I will re-post my question to be clear

the problem is... in fixed width mode, i can not define diffrent fixed/width settings per row-type...

in my example, in can't define diffrent row types for the #Parent1 and the #Child1..

and when i use the row-orietented-mode, i can't find any way to define my column.. because there is no delimiter between my columns..
Posttop
Tony LavinioSubject: fixed-width to XML
Author: Tony Lavinio
Date: 05 Jul 2005 01:21 AM
Sorry, but we do not yet support fields of different sizes by pattern
in fixed-width regions yet. There is a tentative plan to include that
in our next version, but it is not fully decided yet.
   
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.