How to convert a strings representing "yyyyMMdd HHmm" into a time stamp format

[Tetsuro_W]

Hi experts, 

I have a sample date obtained from my customer that contains a string data like for example "20240310 1334".

This indicates time stamp date, so I want to convert this text string data into a time stamp data like "2024-03-10 13:34:00.000000"

Could someone please advise if any way to do this? Any commento will be appreciated.

Thanks in advance.

[LouisDHulst · Accepted solution]

Hi @Tetsuro_W ,

The Prepare visual recipe has a Parse Date processor that can handle this kind of operation (doc).

You would have to create the Prepare recipe, then select the Parse Date processor and use the custom format yyyyMMdd HHmm to get a parsed timestamp. 

[Tetsuro_W]

Hi @LouisDHulst ,

Thanks for your comment! It worked!