Data Conditions Settings Dialog

Use this screen to specify data conditions for the records to be extracted from the input file. Only the records that satisfy the specified data conditions will be output.
For record extraction specifications, see Record Extraction in Extraction Specifications.
For restrictions and notes, see Restrictions and Notes on Record Extraction Function.


Item Explanation

Add To add an extraction condition, specify Item Name, Operator (hexadecimal form), and Condition value within the conditions group (Connected Condition must also be specified for the second and subsequent conditions), and then click the Add button. The extraction condition is added to the Specified Conditions List.
If an error occurs, correct the condition according to the error message.
Update To modify an extraction condition, select the condition you want to modify from the Specified Conditions List, specify Item Name, Operator (hexadecimal form), and Condition value within the conditions group (Connected Condition must also be specified for the second and subsequent conditions), and then click the Update button. The extraction condition is updated on the Specified Conditions List.
If an error occurs, correct the condition according to the error message.
Delete To delete an extraction condition, select the condition you want to delete from the Specified Conditions List, and then click the Delete button. The extraction condition is deleted from the Final Condition List.
Final Condition List The specified data conditions are listed. Record extraction will be performed based on the conditions listed here.
No. Indicates the sequence number of the data condition.
The specified data conditions are applied in ascending order of the sequence number, from 1 to 10.
Connected Condition Indicates the concatenator AND or OR for the data condition, for the second and subsequent conditions.
Item Name Indicates the item name for the data condition.
Operator Indicates the operator for the data condition.
Condition value Indicates the condition value for the data condition.
Hexadecimal form YES is displayed if Hexadecimal form is selected.
Connected Condition If you specify two or more data conditions, select AND or OR as the concatenator between the first condition and the subsequent condition. No initial value is set.
Item Name Specify the item name in the layout definition file that you have specified in Step 2 of the Conversion Wizard. You cannot specify group items or variable-occurrence items.
Operator Specify the operator to be used to compare the data in the input file with the condition value. The specifiable operators vary depending on the data attribute:
Character type attribute =(Complete agreement), Agreement forward, !=
Numeric type attribute =, !=, >, >=, <, <=
Hexadecimal form Check this check box if you want to specify the condition value in hexadecimal. This checkbox is available only for the character type attribute.
Condition value Specify the condition value to be used to extract data records from the input file.
The maximum length of condition value specifications is 150 bytes.
For the numeric type attribute, a number consisting of up to 18 digits (+, -, and . (decimal point) are not included) can be specified.
If no condition value is entered, Data Converter considers that NULL data is specified. You can only omit the condition value when the data attribute is the character string item (M).
*Null condition value can be used for NULL data extraction for CSV/XML-formatted character string items.
To specify a condition value when Hexadecimal form is selected:
Available characters are single-byte alphanumeric characters 0 to 9, A to F, and a to f, and semicolons (;).
Semicolons must be used after the end of a byte. If a semicolon is inserted between bits of a byte, Data Converter omits 0 (hexadecimal) for the low-order bit.
Output Unmatched Record Check this checkbox if you want to output records that do not satisfy the data conditions.
Unmatched Record File Specify the name of the file to output unextracted records.
If there is any input record that does not satisfy the record extraction condition, it is output to this file. Since the unextracted records file contains the data that is yet to be converted by Data Converter, it can be used as the input file for record re-extraction.