[Qgis-user] Importing CSV files

[Werner Macho]

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
<phillip.money at hotmail.com> 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 <werner.macho at gmail.com> 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
>> <phillip.money at hotmail.com> 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
>> > Qgis-user at lists.osgeo.org
>> > List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
>> > Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user
>
>