Skip to main content
Question

Splitting date and time (with no whitespaces)

  • January 19, 2020
  • 2 replies
  • 121 views
M

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
    Evangelist
    • takashiEvangelist
    • 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
    Evangelist
    • takashiEvangelist
    • 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.

     

    Reply


    Helpful Members This Week

    Community Stats

    31,408
    Posts
    119,109
    Replies
    39,030
    Members

    Latest FME

    Terms & ConditionsCookie settings

    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
    A product of
    Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.