search

neo4j / neo4j-browser

Neo4j Browser is the general purpose user interface for working with Neo4j. Query, visualize, administrate and monitor the database.
https://neo4j.com
GNU General Public License v3.0
671 stars 345 forks source link

Fix bug where csv strings were triple quoted #1970

Closed nnecla closed 2 months ago

nnecla commented 2 months ago

This pull request is to remove triple quotes from the csv export of statements.

Before, exported csv:

n.types,n.point,n.cuteness,n.duration2,n.birthDate,n.cool,n.time,n.name,n
"[""Ground"", ""Psychic""]","point({srid:7203, x:3, y:0})",10.3,"""P0M0DT91.123456789S""","""2023-04-28""",true,"""12:50:35.556000000+01:00""","""Baltoy""","(:Query_graph {duration: ""P0M14DT58320S"",types: [""Ground"", ""Psychic""],level: 1,cool: true,cuteness: 10.3,name: ""Baltoy"",duration2: ""P0M0DT91.123456789S"",time: ""12:50:35.556000000+01:00"",birthDate: ""2023-04-28"",point: point({srid:7203, x:3, y:0})})"

After with this pr changes, exported csv:

n.types,n.point,n.cuteness,n.duration2,n.birthDate,n.cool,n.time,n.name,n
"[Ground, Psychic]","point({srid:7203, x:3, y:0})",10.3,P0M0DT91.123456789S,2023-04-28,true,12:50:35.556000000+01:00,Baltoy,"(:Query_graph {duration: P0M14DT58320S,types: [Ground, Psychic],level: 1,cool: true,cuteness: 10.3,name: Baltoy,duration2: P0M0DT91.123456789S,time: 12:50:35.556000000+01:00,birthDate: 2023-04-28,point: point({srid:7203, x:3, y:0})})"

Please see the following doc for csv quote requirements: https://www.ietf.org/rfc/rfc4180.txt