Extractor Type | Description | |
Fixed Position | Counting from zero (0), indicates a fixed number of bytes to be extracted from a record. | |
Property | Description | |
Name | Type the name of the field. | |
Start | Type the first byte to extract from the record. | |
End | Type the first byte that is not included in the extraction. If you enter a negative number (for example, –1), the extractor returns all bytes from the byte specified in Start to the last byte in the record or composite. | |
Mandatory | Optional. Select the check box to require that this field appear in the flat file. If is not selected, the field is not required to appear in the flat file. If it is selected and the convertToValues service validate variable is set to true, errors will be generated if the field does not appear in the flat file. | |
Nth Field | Counting from zero (0), indicates the field that you want to extract from the record. | |
Property | Description | |
Name | Type the name of the field. | |
Position | Type a value to indicate the position of the field that you want to extract from the record. This value cannot be null and must be an integer greater than or equal to zero (0). For example, if you type 1, the second field will be extracted. This option is available only if you specified a field delimiter when configuring your flat file schema. This extractor returns the field as a key–value pair. The key is the name of the field. The value is the String value of the field. | |
Mandatory | Optional. Select the check box to require that this field appear in the flat file. If is not selected, the field is not required to appear in the flat file. If it is selected and the convertToValues service validate variable is set to true, errors will be generated if the field does not appear in the flat file. |