[Qgis-user] Importing CSV files

[Richard McDonnell]

Phillip,
I have copied out what you sent, paste it into notepad and saved it as a 
txt file. I then imported it into QGIS using Add delimited Text Layer, 
making sure to select *Custom delimiters*, and selecting*Semicolon*.
One other thing I done was select *No geometry.
*This has worked perfectly see attribute table below



I hope the above settings work, I am running QGIS 2.14 by the way, 
shouldn't make a difference though.
Regards,

Richard.

On 15/07/2016 13:03, Phillip Money wrote:
> Richard,
>
> I am using Add delimited Text Layer.
>
> Here is a snippet of the data.
>
> 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 22:00, Richard McDonnell <richard.mcdonnell at opw.ie 
> <mailto:richard.mcdonnell at opw.ie>> wrote:
>
>     Phillip,
>     Can you supply a sample of the data, also what version are you
>     running of QGIS.
>     The other thing is are you using *Add delimited Text Layer* or are
>     you just loading the CSV directly?
>     Regards,
>
>     Richard.
>
>
>     On 15/07/2016 12:29, Phillip Money 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 <mailto: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
>
>     -- 
>     *_Richard McDonnell_*
>     *GIS Specialist PgD GIS AssocSCSI*
>     *OPW FRM Data Management*
>     *52 Stephens Green, Dublin 2.*
>     TEL: 01 6476543
>     OPW - Ag féachaint don am atá le teacht - Ag caomhnú ón am atá thart
>     OPW - Looking to the future - Caring for the past
>     <http://www.opw.ie/>
>     Email Disclaimer: http://www.opw.ie/en/disclaimer/
>
>

-- 
*_Richard McDonnell_*
*GIS Specialist PgD GIS AssocSCSI*
*OPW FRM Data Management*
*52 Stephens Green, Dublin 2.*
TEL: 01 6476543

OPW - Ag féachaint don am atá le teacht - Ag caomhnú ón am atá thart
OPW - Looking to the future - Caring for the past

***********************************************************
Email Disclaimer: http://www.opw.ie/en/disclaimer/

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20160715/5c18efaa/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: dhgiajjg.png
Type: image/png
Size: 53450 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20160715/5c18efaa/attachment.png>