I have a Date/time as a string and I need to turn it into something usable. This is an example of what I have: 29 September 2019, 8:50 PM I have been trying to get this to work looking at other examples and this is what I have (doesn't work). LOAD CSV WITH HEADERS FROM 'file:///myfile.csv' AS li…

The LOAD CVS parsing capabilities provide a basic, but usually sufficient set of tools for your purpose. The crucial ETL step seems to bea decent decomposition of the input along its variety of separators. Lets have a look: input "myfile.csv" date,time 29 September 2019, 8:50 PM 30 September 2…

OK, changed "Line" to "line" and it imported data but the data did not import properly. I got this: { "month": "September", "ampm": "PM", "day": 29 } Looks like the comma and the colon are messing things up. How do I deal with those? Jason

I haven't tested it myself, but look at apoc.date.parse ( Neo4j APOC Procedures User Guide )

Thanks ! I'll check this out! Jason

This won't work. apoc.date.parse appears to need a DATE value as input. I have a STRING. I need to pull apart this STRING somehow and then put it back together as a usable DATE. Problems I'm having with this: -SPLIT can not manage more than one delimiter. The comma and colon remain. -How do I co…

I changed this line: t.year = TOINT(date[2]), Into: t.year = TOINT(apoc.text.clean(date[2])), The apoc.text.clean(text) function will strip anything that isn't alpha numeric so I thought it would strip the comma. Nope. I guess comma's are alpha numeric. Oddly, the Year now appears in my data !!…

This is awesome thank you! Jason

Here is another solution; If your string is: "29 September 2019, 8:50 PM" then use this script WITH SPLIT("29 September 2019, 8:50 PM", ',') AS dt1 WITH dt1, SPLIT(dt1[0], ' ') AS dt2, SPLIT (trim(dt1[1]), ' ') As dt3 return toInteger(dt2[0]), dt2[1], dt2[2], dt3[0], dt3[1] result: "29", "Sept…

How to turn string Date/Time into something usable

Graph Academy Newbie Questions

BuilderGuy1 (Builder Guy1) January 20, 2020, 6:34pm 10

Thank you everyone! This has been very helpful!

I'm now trying to get the hour to be in 24 hour format.
The problem I'm having is that I don't know how to ADD two numbers together.
I end up concatenating them together.

I'm using this line in a CASE statement:
WHEN 'PM' THEN toInteger(dt4[0]) + 12
This results in:
"2019-09-29T812:51"

I have been scouring the Cypher manual but I can't find a way to do this.
Any thoughts?

Topic		Replies	Views
How to read date time value not separated by T? Cypher apoc	2	956	January 5, 2019
Parsing date and time separately when loading CSV file Cypher	7	923	June 23, 2020
Import csv format issue: convert str date to datetime format Import / Export	2	175	June 17, 2024
Transforming data format when using LOAD CSV Desktop load-csv	4	3615	November 27, 2021
Loading csv with date fields and default values Cypher apoc , cypher , import	3	131	November 14, 2024

Take the Course Then Join The Aura Agent Hackathon

How to turn string Date/Time into something usable

Related topics

Take the Course Then Join
The Aura Agent Hackathon