I was searching through the forum but did not find any solution to below:
I am trying to convert string to date&time data type. I know of the node “String to Date&time” but that node only accepts one format.
But, I have 2 formats of date one column as below:
here I want to extract these 6 columns as date&time from string data type.
I configured “String to date&time” node to extract using following configurations:
The solution in option 1 will not help as the format change without any pattern and I need for all 5 columns, any column can have any format in any row without fixed pattern.
I am following the solution in option 2 and will see if that works and get back to you with the same.
Hello @ipazin !
None suggestions work for me as mentioned as I just saw my data set has even more formats…
Even regex does not seem to work.
I have some 3-5 formats in one column randomly occurring among the 5 consecutive columns.
the below are the formats:
And I want to convert these to date&time data type.
Is there any other way to handle this?