[Qgis-user] how to avoid the automatic conversion of a session string in a csv file to a number

[Neumann, Andreas]

Hi Tonino, 

Can you try to provide a .csvt file along with the .csv file? It should
have the same name with a different extension. See also
http://anitagraser.com/2011/03/07/how-to-specify-data-types-of-csv-columns-for-use-in-qgis/


Andreas 

On 2015-07-29 10:18, CONTI Tonino wrote: 

> Dear all,
> Can anyone tell me how to prevent qgis automatically convert a csv file from text field to numeric format (double).
> I have a csv file where a field contains texts starting with zero (example: "0420050000000009", with the quotes).
> When I add to my project file as "layer delimited text," I see the data properly in the preview but when the layer is added in this field is not imported the leading zero recognizing the format as numeric.
> I need that the string "0420050000000009" remains unchanged as it represents a unique identifier.
> can you help me?
> Thank You
> Tonino 
> 
> _Dott.Tonino Conti_ 
> _Comune di Jesi_ 
> _Sistema Informativo Territoriale_ 
> _ Tel 0731538312 - fax 0731538513_ 
> _t.conti at comune.jesi.an.it_ 
> _www.comune.jesi.an.it/sit [1]_ 
> 
> _______________________________________________
> Qgis-user mailing list
> Qgis-user at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/qgis-user [2]

 

Links:
------
[1] http://www.comune.jesi.an.it/sit
[2] http://lists.osgeo.org/mailman/listinfo/qgis-user
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20150729/f8142567/attachment.html>