Hi! As I wrote in my first guess - ""87%" is not an integer while "87" is. As long as you have the "%" sign after the digits it will not be read as integer. You can try to read it as String - and convert it afterwards - or you get rid of the "%" sign.
Something like: Balranald (A);87;6;0 will surely be read like you want it. regards Werner On Fri, Jul 15, 2016 at 2:03 PM, Phillip Money <[email protected]> wrote: > Here is the sample. > > LGA_NAME;Non-Indigenous;Aboriginal;Torres Strait Islander > Albury (C);93%;2%;0% > Armidale Dumaresq (A);88%;6%;0% > Ashfield (A);93%;1%;0% > Auburn (C);93%;1%;0% > Ballina (A);93%;3%;0% > Balranald (A);87%;6%;0% > Bankstown (C);94%;1%;0% > Bathurst Regional (A);91%;4%;0% > > I had the data separated by commas, but changed it to semi-colons. Neither > worked. I also change the date to numerical format as in .93. That didn't > work either. > > On 15 July 2016 at 21:56, Werner Macho <[email protected]> wrote: >> >> Hi! >> >> Can you give a sample of the csv file? >> For example if there is 40% inside the column it can't be a integer .. >> >> Would be good to have a look how the data looks like. >> >> regards >> Werner >> >> On Fri, Jul 15, 2016 at 1:29 PM, Phillip Money >> <[email protected]> wrote: >> > I have a CSV file with four columns. The first column is text, and the >> > succeeding columns are percentages. I have set up a csvt file with >> > "String", >> > "Integer", "Integer", "Integer" When I import the file into QGIS as a >> > delimited text layer, QGIS strips out all the percentages. They come in >> > as >> > null values. I have tried a lot of things, but can't get past this. >> > >> > >> > For example, I have tried converting the percentages to numbers and >> > bringing >> > them in that way; same thing happens. >> > >> > >> > I would appreciate any help. >> > >> > >> > Regards >> > >> > >> > Phillip Money >> > >> > >> > >> > _______________________________________________ >> > Qgis-user mailing list >> > [email protected] >> > List info: http://lists.osgeo.org/mailman/listinfo/qgis-user >> > Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user > > _______________________________________________ Qgis-user mailing list [email protected] List info: http://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user
