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
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
- 7843 replies
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:
- 7843 replies
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.
