[Qgis-user] problem reading csv file (numbers read as strings)

[Alexandre Neto]

Well, let's mess things a bit more...

I have opened your csv using this
settings<https://dl.dropboxusercontent.com/u/110618644/Capturar.JPG>
[1].

And both coordinates fields were read as integer (because they have no
decimal part), not texts

Cheers,

Alexandre

[1] https://dl.dropboxusercontent.com/u/110618644/Capturar.JPG


On Tue, Oct 22, 2013 at 2:59 PM, Matteo Ghetta <matteo.ghetta at gmail.com>wrote:

> Thanks for all the replies.
> I'm sure that with qgis 1.8 I had no problem in importing a csv file.
> Anyway, that's my current file:
>
>   ID X Y  2818/22/0834 3480240 5887204  2818/22/0851 3480183 5887073
> 2818/22/0853 3480060 5886803  2818/22/0886 3481095 5886981  B0F 3479888
> 5885731  B12T 3479805 5886002
>
> As you can see there are no decimal numbers. You can find the csv file
> also in attach.
> Another problem: if I import a table (without coordinates and still as csv
> file made in libreoffice) in the map canvas (just drag and drop it), qgis
> still reads the numbers as strings (making the join option with another
> shape file useless).
>
> Cheers
>
> Matteo
>
>
>
>
> 2013/10/22 Ramon Andiñach <custard at westnet.com.au>
>
>> True. A couple if lines would be helpful. Generally QGIS 2.0 is fairly
>> good at guessing, so it would be interesting to see what's confusing it.
>>
>> Have you got the put apostrophes around text turned on?
>>
>> If all else fails you can force QGIS to do what you want.
>> http://anitagraser.com/2011/03/07/how-to-specify-data-types-of-csv-columns-for-use-in-qgis/
>>
>> -ramon.
>>
>> > On 22 Oct 2013, at 20:06, Zirneklitis <eko at lanet.lv> wrote:
>> >
>> > Hard to comment without example.
>> >
>> > Best regards,
>> > Karlis
>> >
>> > Matteo Ghetta wrote:
>> >> ..
>> >> I wrote a table with some field (two of them are x and y coordinates),
>> >> saved as csv and then I tried to upload it in qgis with the "add
>> >> delimited text" option.
>> >>
>> >> Problem: numeric filed are read as strings and not as numbers ..
>> > _______________________________________________
>> > 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
>>
>
>
> _______________________________________________
> 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/20131022/96aea294/attachment.html>