Comma-Separated and Tab-Separated Values Adapter Properties

With a few exceptions, noted in the following table, adapter properties are the same for both the comma-separated values and tab-separted values adapters.

Adapter Names in URL

CSV (comma-separated values)

TAB (tab-separated values)

Table 152. Properties for CSV and TSV Adapters
Property Name	Name in URL	Description
Encoding	encoding	The encoding for the input file when it is not XML; or the encoding for the output file when it is not XML.
Line separator	newline	See Line Separator Values for a list of values.
Separator	sep	The separator value between each value. This can be 'TAB', any single character (a comma ( , ) is the default), or the % XX-escaped value (%2c, for example).
First row contains field names	first	Generated field names depend on the values in the first and number fields. If first=yes and number=no, field names are read from the first row. Any field names after that are named column. xxx, where xxx is the column number, starting from one and including explicitly named columns in the count. If number=yes, extra columns (those after the first) are named just column.
Escape character	escape	This character escapes quotes and separators so that they can be embedded in values. The backslash (\) is the default.
Quote character	quote	A list of characters the adapter should interpret as quotation characters. Double and single quote marks (" ') are the default values.
Number rows and columns	number	If number=yes (no is the default), each row will also have an attribute, named row, which will contain the row number from the source document, starting from one. Also, each column, even those explicitly named, will have a column attribute numbering the column from one. Any empty columns are omitted from the output, but the numbering of subsequent columns will reflect that a column(s) was skipped.

< Previous | Next >

Download a 15 Day Free Trial Now >

See What's New for 2012 in Stylus Studio X14 >

Purchase Stylus Studio X14 Now >

Using Relational Data in XML Applications

"Using Relational Data in XML Applications" By Dr. Michael Kay covers an overview of several common use cases and provides insight into the benefits and drawbacks of using the approaches available today including XQuery and SQL/XML.

Metals, Mining & Crude-Oil Production

It can be very dark and dreary in a mine. That's why metal, mining & crude-oil production are using Stylus Studio as their light when it comes to data integration. See which of these top companies are using Stylus Studio to show them the way to XML!

Semiconductors & E-Components

Buuuuuzzzzz, zappp! There sure is a lot of electiricty flying with these semiconductors & c-component producers. It is because these top companies use Stylus Studio 2006 to light up their work day!

Support for DataDirect SequeLink

Learn about Stylus Studio's support for DataDirect SequeLink, an end-to-end database middleware solution that provides a universal thin client for ODBC, JDBC, ADO or .NET, providing flexibility for both client- and server-based deployments.