[Qgis-user] "Add delimited text layer" can't handle columns containing commas

Andreas Neumann a.neumann at carto.net
Mon Nov 5 11:17:33 PST 2012


Hi,

Using commas in column names will only create problems later on (e.g.
when using SQL-like syntax - where commas are used to separate column
names, or when publishing the layers with QGIS server). You really
should avoid using them.

Andreas

Am 05.11.2012 16:57, schrieb magerlin:
> "Add delimited text layer" can't handle record no 4 because the second field
> contains a comma:
> 
> ID,Navn,x,y,type
> 1,"H.C. Ørstedsvej/Åboulev.",723295,6176730,"Busstop"
> 2,"Ejbyvej/Åbyvej",713648,6178997,"Busstop"
> 3,"Hyldetoften",710639,6180428,"Busstop"
> 4,"Ågerup, Omsorgscentret",698621,6176536,"Busstop"
> 
> <http://osgeo-org.1560.n6.nabble.com/file/n5014034/CSV.png> "
> 
> The record is left out of the resulting shp file.
> 
> But it can be done with the MMQgis plugin :-)
> 
> 
> 
> -----
> Regards Morten
> 
> Qgis 1.8.0 Stand alone installer in Win7 64 bit
> --
> View this message in context: http://osgeo-org.1560.n6.nabble.com/Add-delimited-text-layer-can-t-handle-columns-containing-commas-tp5014034.html
> Sent from the Quantum GIS - User mailing list archive at Nabble.com.
> _______________________________________________
> Qgis-user mailing list
> Qgis-user at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/qgis-user
> 




More information about the Qgis-user mailing list