Is there a way to choose the field delimiter when exporting a CSV with geometry as wkt in QGIS?
I have a shapefile with donut holes and I'd like to export it as a CSV. It's for a partner whose DB doesn't support spatial data.
I followed Greg Krakow's methodology to add a WKT field to my exported file (when exporting to csv, add GEOMETRY=AS_WKT
in the "Layer" field, but the exported field delimiter is a comma:
The problem is that each coordinate pairs of my polygons (and I suspect it will be the same for lines) are separated by a comma too so I can't import the data back into QGIS
With point shapefile, it works like a charm.
Does anyone know if I can choose my field delimited when exporting to CSV? Choose a semicolon for instance?
I search on the web and QGIS's documentation but didn't find anything.
Answer
I was able to export to CSV, using other than a comma, by separating the layer creation options in the Save As.. dialog with linebreaks.
Neither comma, nor space-separating them (even when they were in quotes) worked, but the linebreaks did the trick. To emphasize..
THIS APPROACH WORKED (linebreak-separated):
GEOMETRY=AS_WKT
SEPARATOR=SEMICOLON
LINEFORMAT=CRLF
But these approaches did NOT work...
(space-separated options):
GEOMETRY=AS_WKT SEPARATOR=SEMICOLON
(comma-separated options):
GEOMETRY=AS_WKT, SEPARATOR=SEMICOLON
(quoted, and either space or comma-separated LCOs):
"GEOMETRY=AS_WKT", "SEPARATOR=SEMICOLON"
As @underdark noted, there are some additional options discussed on the OGR CSV driver page you may want to be aware of. Specifically, the SEPARATOR
parameter will accept either SEMICOLON
or TAB
in addition to COMMA
. Also, you may want to experiment with the LINEFORMAT
parameter, which supports either CRLF
(dos/windows) or LF
(unix).
A picture says a thousand words, so here's a screen grab. :)
No comments:
Post a Comment