Date & time error

[mohammad_alqoqa]

Hey everyone,
I’m encountering an issue with a CSV file. It seems that some rows are shifted to the right. Out of over 300,000 rows, there are approximately 600 rows like this. I’m not sure if this is due to a comma or some other reason. Even if I want to delete these rows, I’m unsure about how to do it. I’ve attempted to use the row filter node, but it’s complicated. Additionally, the data type is supposed to be date and time, but it’s showing as a string, and I’m unable to convert it because of these rows.
Any help would be appreciated, but I would prefer a step-by-step explanation.

link of dataset

Kickstarter Projects

[mohammad_alqoqa]

I use the last version 5.3.1

[mlauber71]

@mohammad_alqoqa you could try and allow short lines in the settings.

Another option would be we the R package readr.

use R library(readr) to read (messy) CSV file into KNIME – mlauber71

[mohammad_alqoqa]

Thank you for the reply

As for the first solution, I tried it but no change.

As for the second solution

Well. What you gave me seems to be the result of a lot of experience.

Since I received your reply, I have been trying to understand how I can benefit from it, but unfortunately, I could not reach a solution. I tried putting the path for the file in more than one place, but I do not know the full picture of how to use most nodes. I have not used most of them before.

Thank you very much

[mlauber71]

@mohammad_alqoqa maybe you could provide a sample file with the problem to load there data.

About using R and knime I have set up this guide.

https://medium.com/low-code-for-advanced-data-science/knime-and-r-installation-across-operating-systems-some-remarks-6494a2a498cc

Finally it might be worth thinking about using more stable file formats to transfer data although often one does not have a choice.