Convert Fixed Width to XML

Use the Convert Fixed Width to XML document wizard to convert a fixed-width text file to an XML document. To display the Convert Fixed Width to XML dialog box, select File > Document Wizards in the Stylus Studio menu bar, and double-click Fixed Width to XML.

Fields

Input URL

Specifies the absolute path name of the fixed width file you want to import.

Input Encoding

Specifies the character encoding of the text file being converted. The default for your platform is typically UTF-8 or UTF-16. If you do not specify a value, the wizard uses the default for your platform.

Root element name

Specifies the name of the root element in the resulting XML document. The default is document.

Row element name

Specifies the name of the row elements in the resulting XML document. The default is row. The row elements are the children of the root element.

Column names are

The columns are the children of the row elements.

Generated indicates that the wizard should insert the default column names, which are value1, value2, value3, and so on.

In file indicates that the first line in the fixed width file contains the values for the column names.

Specified here indicates that you are typing the names of the columns in the Column Definitions group box.

Column Definitions

Double-click the appropriate field to enter the names and widths of the columns.

Map value to

Child element indicates that the wizard should map the column values to child elements of the row elements.

Attribute indicates that the wizard should map the column values to attributes of the row elements.

Make Default

Stores the current settings in the Windows registry. Stylus Studio uses these default values as the initial settings the next time the dialog box is opened.

Reset Default

Resets the default values of the settings to the values they had when Stylus Studio was installed:

document is the root element node

row is the row element name

Column names are generated as value1, value2, value3, and so on

Column values are mapped to children of row elements

Comma ( ,) is the delimiter character

Double quote ( ") is the quote character

UTF-8 is the default encoding of the file being imported