Hi, can someone please look at what I am doing wrong?
I am trying to use String to date&time node and can`t seem to parse this format
Here is what I wrote down:
And here is the error I keep getting
Hi, can someone please look at what I am doing wrong?
I am trying to use String to date&time node and can`t seem to parse this format
Here is what I wrote down:
And here is the error I keep getting
hi @Dalmatino16 ,
a possible problem I see is that hour looks separated by two spaces from yyyy
Hi, I get the same error whether I use one or two spaces between years and hours. I copy pasted column im MS Word and turned on feature to show empty places with dots. Here is how the input looks like
I’m pretty sure some string manipulation is needed before you can parse it into a Date&Time type. Let’s beautify the string into a nice consistent format:
". "
with "."
Now the date format should conform to "d.M.yyyy H"
(undefined minutes and seconds are ok)
A regex in the String Manipulation node should do the job
regexReplace(strip($column1$),"^.*?(\\d+).*?(\\d+).*?(\\d+).*?(\\d+).*$" , "$1.$2.$3 $4")
Thank you Thyme for the idea.
And thank you Duristef - it did the trick.
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.