Multiple Date Pattern Transformer
Description
Parses date strings (with time information) according to the specified patterns and converts them to regular context data date objects.
The plugin allows to configure multiple patterns. Each configured attribute is parsed with the configured patterns until the first succeeds (the order corresponds to the configured order). If none of the patterns leads to a successful transformation, the transformation fails. Using this transformer, inconsistencies in the input data format can be handled. Assuming the self-registration date appears with a time offset (e.g. 2024-03-25 14:45:25+02) and sometimes without (e.g. 2024-03-25 14:45) for example.
Values which have been transformed by this transformer are guaranteed to be of type java.util.Date.
May be used by
Properties
Attributes (
attributes) Description
Selects the attributes to apply the replacement to.
Use the asterisk character ("*") to replace all attributes
Use the asterisk character ("*") to replace all attributes
Attributes
String-List
Mandatory
Date/Time Patterns (
dateTimePatterns) Description
List of date/time patterns. Each configured attribute is parsed using these patterns until the first one succeeds. The order corresponds to the configured order of this list. If parsing an attribute fails with all the patterns, the transformation fails.
Attributes
Plugin-List
Mandatory
Assignable plugins
YAML Template (with default values)
type: MultipleDatePatternTransformer
id: MultipleDatePatternTransformer-xxxxxx
displayName:
comment:
properties:
attributes:
dateTimePatterns: