Processor Editor ASCII Tab

Use the ASCII tab to configure the file parser processor ASCII settings.

The ASCII tab is available for file parser processors.

This tab is editable only when Parser Type on the Processor editor Details tab is set to ASCII.

ASCII Parser Definition Area

Field	Use
Record Delimiter	Identifies the type of expression that constitutes a new record.
Name	Enter the name of the record.
Record Type	Select the type of the record. If a header record is present, it is always the first record in a file. If a trailer record is present, it is always the last record in the file. The body records are all the records in between.
Field Delimiter	Select the character that separates fields within the record. If you select Custom, the Custom Field column becomes editable and a single character value must be entered in this field.
Custom Field Editor	Select the custom single character field delimiter. This column is enabled only if Custom is selected in the Field Delimiter column.
Aggregate Extra Fields	Specify whether the remaining data in a record should be appended to the last field element in the records list. This is useful for records that have a fixed set of information at the beginning of the record and a variable set of information at the end of the record. The fixed set can be represented as normal using field elements, and the variable set can be aggregated into the final field element for further parsing in processor code.
Ignore	Specify whether this record should be processed. Enable when the header or trailer records exist and the data that they contain does not need to be processed.
Skip Consecutive	Specify whether consecutive delimiters should be treated as multiple delimiters or as a single delimiter. Oracle recommends that you leave this option unchecked as it is preferable to report that there is an empty field between consecutive delimiters. For example, if a CSV file contained a record of "1,2,,4", then it is likely missing the 3rd field for a reason, and this fact should be reflected in the record data. However, there are cases when it is preferable to skip consecutive delimiters. This usually occurs when the field delimiter is a blank space. The reason for setting it to true (checked) in this case is that incoming records often contain multiple space between fields.
Move Up Move Down	Reorder selected record definition.
Import	Import record definitions from a sample file.
Remove	Remove the selected record definition.
Add	Create a record definition.

Record Definition Details Area

Field	Use
Name	Enter the name of the field, which is used to generate a getter method on a record class that can be used by subsequent processors for retrieving the data.
Ignore	Specify whether this field should be processed. If checked, a getter method is not generated for this field, and the data in this field is not accessible to the action.
Container	Specify a grouping character, which allows field-delimiter characters to be treated as regular data, provided they are contained within the specified container character. The container must be a single character, if specified.
Container is Optional	Specify whether the container character is mandatory for every record or if the container character is optional.
Move Up Move Down	Reorder the selected field definition.
Remove	Remove the selected field definition.
Add	Create a field definition.