Hi,
I have date and time value in a column which look like '19960108031100'. Now I want to split into two columns i.e. date and time. Could anyone guide on how to do that?
Regards
Yasir
Page 1 / 1
Hi @muhammad_yasir, the datetime value is formatted with a Standard FME Date/Time Format - %Y%m%d%H%M%S. If the source format is always so, you can use a DateTimeComverter to delimit it into date and time with a specific character (e.g. comma), then split the result with the AttributeSplitter.
Example:
Hi @muhammad_yasir, the datetime value is formatted with a Standard FME Date/Time Format - %Y%m%d%H%M%S. If the source format is always so, you can use a DateTimeComverter to delimit it into date and time with a specific character (e.g. comma), then split the result with the AttributeSplitter.
Example:
Alternatively, this workflow is also available.
