[DataSpider Servista] About date and time format conversion of sending date and time that can be received by email and acquired.
I would like to convert the transmission date and time "Mon May 14 11:33:30 JST 2018" that can be obtained by receiving mail with the mail adapter to "yyyy/MM/dd HH: mm: ss".
It can be converted to the date format assumed by [Replace for each string] logic that specified [Regular expression replacement] logic or [Partial match] or [Partial replacement]. In addition, the transmission date and time are acquired from the schema "Sending date and time (reception date and time)".
Using the [Replace for each string] logic, it is possible to replace the month with a numeric value by "partial match" and "partial replacement" from the transmission date and time of the data input in Mapper (May → 05).
From the result of the [Replace by String] logic, it is extracted only the parts required by the [regular expression substitution] logic.
Pre-replacement character string:... (\d\d) (\d\d)(\d\d:\d\d:\d\d) JST (\d\d\d\d)
Replaced string: $4/$1/$2$3
Please refer to the help below for details of each logic.
[Mapper Logic Guide]-[String]-[Substitute for Each String]