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

[Matteo Ghetta]

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
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20131022/97b237df/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: table_coordinates.csv
Type: text/csv
Size: 164 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20131022/97b237df/attachment.csv>