The Unicode Text Adapter
allows you to process both Unicode and ANSI text files. Configure a Unicode text connection when using the Unicode
Text Adapter or another adapter that supports Unicode data and that may
contain Unicode data. By default, this feature is not enabled. You must select it
if this DTS file is used with Unicode data.
Warning: All of the data sources in a single DTS must provide the same level
of Unicode support. Creating a DTS
file that inserts Unicode data into a non-Unicode data source may corrupt the target data.
TIBCO Scribe® Insight allows you to view and process both Unicode and ANSI text files when working
with connections that are Unicode-compliant. For more information, see Working With Unicode Data.
Note:
If this DTS file uses Turbo Text mode to speed up
your integration, Support Unicode data
must not be selected. For
more information about using Turbo Text mode, see the Performance
Tab.
See Connecting to a Text Source for information
about determining which text connection to use.
Before you begin, verify where your text files reside.
To configure a Unicode text connection
In the Workbench, click View > Connections. The Connection Manager appears.
Click
New to begin adding a new Unicode
or Unicode-compliant text connection.
From the Data Sources tree,
expand Adapters and double-click the Unicode Text
node. The Configure — Adapter for
Unicode Text dialog box appears.
Click Browse. The Browse for Folder dialog box appears.
Browse to the folder that contains
your text data and click OK. The File Layout dialog box appears, with the following information:
Data
Source Name — Selected folder name by default. You
can optionally change the Data Source Name.
Directory — Full path to the selected folder.
Available
Files — All files with a .txt or .csv extension.
In Available Files,
select the file you want to configure and click Configure
File Layout. The Table Configuration of the File Layout
dialog box appears.
If you want to change the name of the table, in Table
Name, enter a new name.
If you want to change the delimiting character the file uses, in File
Type, select the new delimiting character.
If you select User Defined, in Delimiting Character, specify the delimiting character to use.
In Text
Qualifier, specify the character used to enclose text that contains spaces:
None — No character encloses text. Use this option if you know your text does not contain spaces.
" (Double quotation)
' (Single quotation)
Note:
Make
sure that the text qualifier you select does not appear in your data, or the row fails.
The most common example of this is using
a single quotation (') as a text qualifier where you have data that includes
apostrophes. For example LastName = "D'Arcy"
or Company = "'Liza's Beautiful Blooms".
Column
Names in First Row — When you first open the Table Configuration
tab, the columns are labeled Field1, Field2, and so on. If this table
has column names, select Column Names in First Row to replace Field1,
Field2, ... with the available column names (from the first row in the
table).
If you want the table column names to appear in the first row, select the Column Names In First Row checkbox. If this option is not selected, the columns are labeled Field1, Field2, and so on.
If you want to change the period (.) separator used for decimal values, in Decimal
Symbol, enter the symbol to use. For example, by default, a numeric value appears as 2345.65. If
you change the Decimal Symbol to a
comma, that value appears as
2345,56.
If you need to change the encoding type for this file, in Default Encoding, select the appropriate type. This setting affects how ANSI files are read from or written to. For example, an ANSI file with French characters could be set to MS Windows Western European to display the characters properly.
Note: Default encoding is an advanced feature for experienced users.
Click the Field Configuration tab.
If you want to change the default name assigned to the selected column, in Column
Names, enter a new column name. By default, the columns are named Field1, Field2, and so on.
If you need to change the type of data in the file, in Data Type, select the correct data type for the file.
If you need to change the default length of text fields, in Width, enter the number of characters permitted in the field, up to 255 characters.
If your data includes Date/Time fields, in Date/Time Format, you must specify a format.
You can either select one of the formats from the drop-down list, or enter
your own format. See Date/Time Formats
for detailed information.
Click OK. You return to the Configure - Adapter for Unicode Text dialog box.
Click
OK. You return to the Connection
Settings dialog box.
Note: Connection names can be up to 32 characters long.