- Top Category > General Questions > DataSpider Servista > [DataSpider Servista] I would like to check the format of date data and make sure that errors are not captured.
Search via FAQ No.
NEW
[DataSpider Servista] I would like to check the format of date data and make sure that errors are not captured.
An Excel file sometimes contains a value other than a date (full-width character) in a column set as "Date" so I would like to check it.
Is it possible to extract only the data that is correctly set as a date as a result of the check?
- Category :
Answer
You can use the "Data Check" icon to check a value and a format of the input data and output the checked result in a selected format.
From the property of the "Data Check” icon, by selecting the "Required Settings" tab and setting the “Data Check Condition List" "Output Record" you can output the data check and the target data.
Example
The following settings are used when the 1st column item read from an Excel file is a date item and data whose item value matches the date "yyyy-MM-dd" format is only output.
- Data check condition list
Column Number: 1
Required: unchecked
Type: Date/Time
Minimum: Unspecified
Maximum: unspecified
Optional: DF = yyyy-MM-dd
Regular expression: unspecified
- Output records: only output records that match conditions
■ Setting Points
- Option items can have type-specific settings in the “key = value” format.
In the example, the key value is "DF" to specify the format of the date/time type. The value specifies the format of the date to check "yyyy-MM-dd".
*For details on the optional sections, please refer to the online help for the "Data Check" icon.
- By specifying "Output only records that match the conditions" in the output record, only data that matches the condition specified by the option is output. (In the above example, it is output to CSV.)
■Please refer to the product's online help for advanced settings for the "Data Check" icon.
Online Help: [Adapter]-[Basic]-[Process]-[Data Check]
- Version Information
- Ver.3.2SP2 or later