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

[Alex Mandel]

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
>>
>