Moises,
as far as I can see with your example, the CSV driver behaves "properly"
in reading and writing of field values with line breaks.
It follows the "Fields with embedded line breaks must be quoted" rule of
https://en.wikipedia.org/wiki/Comma-separated_values
$ ogr2ogr out.csv /vsizip/dataframe.zip
$ cat out.csv
id,descriptio
"1",This is my third row
"2","this is
my string
"
"3",This is my third row
$ ogrinfo out.csv -al
INFO: Open of `out.csv'
using driver `CSV' successful.
Layer name: out
Geometry: None
Feature Count: 3
Layer SRS WKT:
(unknown)
id: String (0.0)
descriptio: String (0.0)
OGRFeature(out):1
id (String) = 1
descriptio (String) = This is my third row
OGRFeature(out):2
id (String) = 2
descriptio (String) = this is
my string
OGRFeature(out):3
id (String) = 3
descriptio (String) = This is my third row
But in your example using /vsistdout/ and -lco CREATE_CSVT=YES is going
to result in an invalid CSV file which will mix both the .csvt and .csv
content
Even
Le 24/04/2023 à 13:34, Moises Calzado via gdal-dev a écrit :
Hello!
We're trying to convert a Shapefile into a CSV using ogr2ogr and we're
having some issues while dealing with some columns that contain line
breaks inside their values. If we have a line with the following
string, ogr2ogr detects that the line break is a new line and it
returns two lines.
"this is my \n value"
That's the command that we're executing:
ogr2ogr -f CSV -skipfailures -makevalid /vsistdout/
/vsizip/shapefile.zip -simplify 0.00001 -dim XY -t_srs EPSG:4326
-lco GEOMETRY=AS_WKT -lco GEOMETRY_NAME=geom -lco CREATE_CSVT=YES
> result.csv
Is this an expected behaviour, or is there any way to avoid this?
Sharing an example Shapefile so that you can try to reproduce that
behaviour:
https://drive.google.com/file/d/1gFqfTP02KTFoavJyyO-Ix05YwZB2tS24/view?usp=sharing
Thanks so much in advance,
Regards.
--
*Moises Calzado*
Support Engineer
+34671264286 | mcalz...@carto.com | CARTO <https://www.carto.com/>
<https://spatial-data-science-conference.com/2023/london/>
_______________________________________________
gdal-dev mailing list
gdal-dev@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/gdal-dev
--
http://www.spatialys.com
My software is free, but my time generally not.
_______________________________________________
gdal-dev mailing list
gdal-dev@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/gdal-dev
