Is it possible to check the format of date data so that only errors are not extracted?

Question

There are cases where a column set as date in an Excel file contains values other than dates (multi-byte characters), and I would like to check this.
Is it possible to extract only the data that is set correctly as a date as a result of the check?

Answer

The Data Check operation checks the value and format of input data and outputs the checked results in the selected format.

By setting the [Data check condition list] and [Output record] from the Required Settings tab in the properties of the Data Check operation, data checking and output of the target data can be achieved.
　
Example

If the first column of data to be imported from an Excel file is a date item and only data whose value matches the format of year-month-date ("yyyy-MM-dd") are to be output, set the property as follows

[Data check condition list]
　Column number: 1
　Required: Not checked
　Type: Date/time
　Minimum: Not specified
　Maximum: Not specified
　Option: DF=yyyyy-MM-dd
　Regular expression: Not specified

[Output record]
　Output only records matching conditions

Key Points

• Type in Data check condition list can be given to option terms in the "key=value" format.
  In the above example, to specify a date/time type format, specify "DF" as the key value and the format of the date to be checked "yyyy-MM-dd" as the value.
  *Please refer to the manual page in the supplementation section below for more information on the optional terms.
  
  
• By selecting "Output only records matching conditions" in the [Output record] field, only data that matches the conditions specified in the option will be output.

Supplementary information

Please refer to the following page for other detailed settings of Data Check operation.

Data Check
https://www.hulft.com/help/en-us/HULFTSquare/Content/Designer/Connector/proc_data_check.htm