Skip to main content
Question

Splitting date and time (with no whitespaces)

  • January 19, 2020
  • 2 replies
  • 120 views

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

2 replies

takashi
Influencer
  • January 19, 2020

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:


takashi
Influencer
  • January 19, 2020
takashi wrote:

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.

 


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings