SSDN - fixed-width to XML

XML Editor

Sign Up

Search

Options

Chat

Help

News

Log in

Not Logged in

Conferences

	Stylus Studio Feature Requests (1192)
	Stylus Studio Technical Forum (14621)
	Stylus Studio - Registrar en o... (1)
	Stylus Studio - Registrar en o... (2)
	Can a pipeline send a file by ... (2)
	After Updateing WIN10 to WIN11... (12)
	Where do I add the custom java... (3)
	Where is the Diagram tab? (5)
	Applying XSLT to Word DOCX/XML (2)
	CSV conversion via ConvertToXM... (1)
	Text symbols in SS not same as... (4)
	Exposing xquery as webservice ... (6)
	Syntax Identifier (2)
	Saving a Converted XML as an X... (5)
	Output document cannot be pars... (4)
	Archiving output from conversi... (1)
	EDIFACT guideline from Stylus ... (3)
	CSV file putting all the data ... (5)
	Can't install Home version 64b... (5)
	presale - Can I covers this sc... (5)
	Problem with UNB (5)
	Splitting EDIFACT files pipeli... (4)
	[1-20] [21-40] [41-60] 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

Tarek Tarek

Subject: 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

Tony Lavinio

Subject: 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

Tarek Tarek

Subject: 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..

Tony Lavinio

Subject: 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.

Tarek Tarek

Subject: 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!

Tarek Tarek

Subject: fixed-width to XML
Author: Tarek Tarek
Date: 27 Jun 2005 06:47 AM

does the new Release 3 support this feature ?

Tarek Tarek

Subject: fixed-width to XML
Author: Tarek Tarek
Date: 27 Jun 2005 06:48 AM

does the new Release 3 support this feature ?

(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

Tarek Tarek

Subject: 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..

Tony Lavinio

Subject: 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.

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 to Conference:

Log In Options Username: Password:

Site Map | Privacy Policy | Terms of Use | Trademarks

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.