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

[John Callahan]

You're correct.  That way probably would be the preferred work-around.

- John



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

> I agree quotes should work but I've found many parsers to not follow the
> expectation on this. As for semicolons I only meant as the delimiter
> leaving the commas inside your text. That way you can tell the parser
> that ; is the separator between records.
>
> Thanks,
> Alex
>
> On 06/20/2011 01:04 PM, John Callahan wrote:
> > 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
> >>
> >
>
> _______________________________________________
> 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/9eba0027/attachment.html>