I have a data file (here) which I have put in knime but now need to take the time away from the date column. I tried using cell splitter, but nothing is happening when I tell it to split on " ". Is there a way of telling it to split after “NN:NN”? Thanks in advance. Workflow attached!
Kazachestvo.knwf (1.7 KB)
Have you tried the Extract Date&Time Fields node?
1 Like
Yes, but it didn’t work
Your workflow is empty.
I manually extracted several dates from your json file and split the time string with a single space. Bear in mind these are strings not date/times. The original format is very non-standard.
1 Like
Thanks. Yes, their time and date is very non-standard, I have tried uploading the workflow again. Hopefully this time it contains data
Kazachestvo.knwf (1.7 KB)
Kazachestvo.knwf (87.6 KB)
That seemed not to do it- try this one instead. I downloaded it and it seemed to contain my workflow.
Did you look at the workflow I posted? The workflow you uploaded doesn’t contain the data since you have the reader pointed to your local system. You need to add a data folder to your workflow and put the data there and then point the reader to relative to current workflow. In the meantime I copied the separate data file you posted. I corrected the Cell Splitter in your workflow in accordance with the example I posted and it works correctly.
I didn’t see a workflow on your post, no. All I saw was a link to a community forum for time/ date splitter and table creator nodes
Click on the link and you can download it from the Hub. Here’s a screenshot of the change you need to make.
1 Like
Oh, I don’t need quotation marks? THANKS! I was convinced I needed quotation marks every single time I tried that!
No. One space. Please mark “solved” if you’re satisfied.
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.