Geek Answers Handbook

Neo4j: how to use Integer or String with special characters as identifier / name for Node

How to use Integer or String with special characters as identifier / name for Node.

For example, I wanted to create this Node with a label as Category:

CREATE (000-116880:CATEGORY {PartnerCode:"ABCD12345", MerchantCode:"XXXX_0001", Name:"XXXX ABCDE", Leaf:1, MerchantCategoryID:125})

or

CREATE (1234:CATEGORY {PartnerCode:"ABCD12345", MerchantCode:"XXXX_0001", Name:"XXXX ABCDE", Leaf:1, MerchantCategoryID:125})

Both of these statements fail. In short, I also cannot use “000-116880” as the Node name, and I cannot use 1234 as the Node identifier / name.

My goal is to create a Node for each category and use its category code as Node, and then assign relationships between categories using their category codes. Therefore I want:

CREATE (000-116880:CATEGORY {PartnerCode:"ABCD12345", MerchantCode:"XXXX_0001", Name:"XXXX ABCDE", Leaf:1 ,MerchantCategoryID:125})

parental

CREATE (000-226880:CATEGORY {PartnerCode:"ABCD12345", MerchantCode:"XXXX_0001", Name:"XXXX ABCDE", Leaf:1 ,MerchantCategoryID:225})

Can anyone provide an example using Cypher statements.

+4
1

('), , , .

CREATE ('000-116880':CATEGORY
        {Leaf:1,
         MerchantCategoryID:125,
         MerchantCode:"XXXX_0001",
         Name:"XXXX ABCDE", 
         PartnerCode:"ABCD12345"})
+3

More articles:


All Articles