Configuring a Read Schema (Delimited)
You can configure a delimited read schema using Business Object Editor.
Procedure
-
Configure attributes in the Reader Delimited Business Object.
For detailed information about these attributes, see Read Schema (Delimited) Reference.
-
In the
Attributes panel, click
Add to add some fields.
The name of the field is generated automatically as field, field1, field2 and so on. You can edit the field names. With the Add, Remove, Up and Down buttons, you can add or remove attributes, move attributes up and down.
-
Configure the Type, Constant, and Sample Value columns for the added fields.
- Type
The data type in the corresponding field in the file is converted before publication.
If the dateTime type is used, you must specify the pattern and locale: right-click the field name and select Set locale and pattern, and then select a supported locale and pattern from the list.
The record type is used to interpret a delimited record embedded within another delimited record. Currently, delimited records that are identified by a constant field value support this feature. When this is selected, it brings up a pop-up dialog which displays the base records that are defined.
- Constant
Available only when you have selected Field Value in the Identify Type field. Enter a constant value for the appropriate field.
- Sample Value
The value is set to <unknown> if the Display Wizard panel is not extended. It shows the actual value when the Display Wizard panel is used and the line in the file is highlighted. You can remove or shuffle the fields.
- Type
-
Create fields and the names of the fields using the
Display Wizard panel.
- Select the encoding of the file content. Before opening the file, you have to select the file content correctly.
- Click Browse to navigate to the file.
-
After identifying the desired file, click
Open.
The file content is displayed in the Display Wizard window.
- Highlight the line where you want to create a file record, and click Create.
This creates fields corresponding to the line using the specified delimiter as the reference. The generated fields are field, field1, field2, and so on by default.The Generate Names feature can be used if the records in the file are actually headers or structural representations of the actual data record. When this feature is used, the actual field names specified in the structural representation are generated and used instead of the default names.