|
The Text File Data Object
The Text object allows you to access most types of row/column based text files. You can define fixed width or delimited, as well as DOS and UNIX style text files.
Properties
Action |
Describes the action to take for output streams. Ignored for input streams. Valid options are:
| ||||||||||||||||
Alias |
Alias identifier. Aliases are used on all design objects to simplify coding and to ensure each object has a unique identifier. | ||||||||||||||||
ColumnLayout |
The column layout (or file structure) of the table. Click on the Ellipse (...) button to fill in the column layout, or select an existing column layout from the repository. | ||||||||||||||||
Comments |
Comment area to give descriptive text about the data object and its purpose. | ||||||||||||||||
DelimiterType |
If the file is a delimited text file, specify the type of delimiter used.
| ||||||||||||||||
DelimiterTypeOther |
If the Delimiter type is other than tab, space, or comma you should set the DelimiterType to Other and specify the numeric character code of the text files delimiter in this property. For instance, if the delimiter is the # sign you would enter: 35 (see the Ascii Chart for common character codes) | ||||||||||||||||
EOFMarker |
The End-of-File marker used in the text file.
| ||||||||||||||||
FilePath |
The filename of the text file you want to read or write. This represents the filename WITH the full Path. | ||||||||||||||||
FirstRowColumnHeaders |
True/False. Specifies whether the first row in the text file represents the column headers. In this case, the first row will be ignored when reading the file. When writing the file, the first record written will be the column headers. | ||||||||||||||||
LayoutType |
Delimited/Fixed Width. Specifies whether the files columns are delimited or fixed width. | ||||||||||||||||
Name |
Descriptive name for this object. You can enter any text to describe the object | ||||||||||||||||
StringsWrappedInChar |
Specifies whether the String-based columns (String, Varchar, Char) are wrapped in a special character, such as the double quote character (") = 34. (See Ascii Chart) | ||||||||||||||||
TextEncoding |
Text encoding gives you the capability to handle different types of encoded text files such as ASCII, UTF and Unicode.
|
© 2003 - 2007 Relational Solutions, Inc. - All rights reserved