[Qgis-user] Delimited text plugin with fields containing commas

[John Callahan]

I use semi-colons when I can but have run into situations where commas are
necessary, such as names of places.  I agree with the work-around and I've
done that before.   As long as quotes (") are included around the values, it
should work, and I believe it was working for a while.

- John

***********************************
John Callahan, Research Scientist
Delaware Geological Survey
University of Delaware
URL: http://www.dgs.udel.edu
*******************************


On Mon, Jun 20, 2011 at 3:59 PM, Alex Mandel <tech_dev at wildintellect.com>wrote:

> On 06/20/2011 12:35 PM, John Callahan wrote:
> > Has anyone seen this problem with the Delimited Text plugin?  I am seeing
> > this in today's download of QGIS 1.7 standalone on Windows, and on a
> recent
> > install through OSGeo4W of 1.8-trunk.
> >
> > "Delimited text" plugin doesn't allow to load csv file with field with
> > commas
> > http://hub.qgis.org/issues/2208
> >
> > - John
>
> I have had that problem before, with lots csv import tools (not just
> qgis). Are you using commas to separate the values too? I usually have
> much better success changing that to ; or |
> so instead of "2","test,test","1"
> "2";"test,test";"1"
>
> Easiest way to swap out the delimiter is to use OpenOffice/LibreOffice
> and change it when saving.
>
> Thanks,
> Alex
> _______________________________________________
> Qgis-user mailing list
> Qgis-user at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/qgis-user
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20110620/fb1a5938/attachment.html>