Im brand new to Neo4j and cypher and Im stuck on the import stage.
In CSV file I have Customer column with customers having "firstname surname" or "firstname middle name surname"
I started with
< LOAD CSV WITH HEADERS FROM 'file:///ClassSessionEnrollmentsExport.csv' as row
UNWIND split(row.Customer," ") as Customer
Which separates the names
I then have been trying to COUNT the number of " " in each row using the count feature
<count(split(row.Customer," ") as Customernumber/>
Hoping I could then use a WITH function to attribute firstname and surnames count<2 and firstname middlename and surname on the ELSE
I expect this to be a simple question for some, but Ive already lost a few hours before posing this question, so any help would be appreciated.
- neo4j version 4.3.2 Community edition