- Top Category > General Questions > DataSpider Servista > [DataSpider Servista] I tried to convert the format with date and time formatting logic, but I could not get the expected result.
Search via FAQ No.
NEW
[DataSpider Servista] I tried to convert the format with date and time formatting logic, but I could not get the expected result.
I tried to convert the format using date/time formatting logic for date and time format data, read by CSV file read processing, but the result was not as expected. Please explain the cause and a way to resolve this problem.
- Category :
Answer
■Cause
The Data read from the CSV file reading process is treated as a string type. Because the date type is specified in the input handler of the date and time formatting logic, the result may not be output as it is set.
■Workaround
After you change the date type at a time from a string type in the date and time of Parse logic, please convert in the date/time formatting logic.
■Supplementary
After parsing date and time, if the value is not output properly, even when it was converted by date and time formatting logic, the settings of the mapper column may be incorrect. In this case, please set the mapper schema again.
Reference Information
- Date and time formatting logic
https://www.hulft.com/help/en-us/DataSpider/dss42sp2/help/en/mapper/document/logic/iso8601ToCustom.html
- Date and time Parse
https://www.hulft.com/help/en-us/DataSpider/dss42sp2/help/en/mapper/document/logic/customToIso8601.html