<html>
<head>
<meta content="text/html; charset=utf-8" http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
Phillip,<br>
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 <b>Custom delimiters</b>, and
selecting<b> Semicolon</b>.<br>
One other thing I done was select <b>No geometry.<br>
</b>This has worked perfectly see attribute table below<br>
<br>
<img src="cid:part1.00080202.07000508@opw.ie" alt="" height="220"
width="300"><br>
<br>
I hope the above settings work, I am running QGIS 2.14 by the way,
shouldn't make a difference though.<br>
Regards,<br>
<br>
Richard.<br>
<br>
<div class="moz-cite-prefix">On 15/07/2016 13:03, Phillip Money
wrote:<br>
</div>
<blockquote
cite="mid:BLU436-SMTP1029597E92C9D6AA6CAA7DDF9330@phx.gbl"
type="cite">
<div dir="ltr">
<div>Richard,<br>
<br>
</div>
I am using Add delimited Text Layer. <br>
<br>
Here is a snippet of the data.<br>
<br>
LGA_NAME;Non-Indigenous;Aboriginal;Torres Strait Islander<br>
Albury (C);93%;2%;0%<br>
Armidale Dumaresq (A);88%;6%;0%<br>
Ashfield (A);93%;1%;0%<br>
Auburn (C);93%;1%;0%<br>
Ballina (A);93%;3%;0%<br>
Balranald (A);87%;6%;0%<br>
Bankstown (C);94%;1%;0%<br>
Bathurst Regional (A);91%;4%;0%<br>
<br>
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. <br>
</div>
<div class="gmail_extra"><br>
<div class="gmail_quote">On 15 July 2016 at 22:00, Richard
McDonnell <span dir="ltr"><<a moz-do-not-send="true"
href="mailto:richard.mcdonnell@opw.ie" target="_blank">richard.mcdonnell@opw.ie</a>></span>
wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0
.8ex;border-left:1px #ccc solid;padding-left:1ex">
<div bgcolor="#FFFFFF" text="#000000"> Phillip,<br>
Can you supply a sample of the data, also what version are
you running of QGIS.<br>
The other thing is are you using <b>Add delimited Text
Layer</b> or are you just loading the CSV directly?<br>
Regards,<br>
<br>
Richard.
<div>
<div class="h5"><br>
<br>
<div>On 15/07/2016 12:29, Phillip Money wrote:<br>
</div>
</div>
</div>
<blockquote type="cite">
<div>
<div class="h5">
<div dir="ltr"> 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.<br>
<br>
<br>
For example, I have tried converting the
percentages to numbers and bringing them in that
way; same thing happens.<br>
<br>
<br>
I would appreciate any help.<br>
<br>
<br>
Regards<br>
<br>
<br>
Phillip Money<br>
<br>
<br>
</div>
<br>
<fieldset></fieldset>
<br>
</div>
</div>
<span class="">
<pre>_______________________________________________
Qgis-user mailing list
<a moz-do-not-send="true" href="mailto:Qgis-user@lists.osgeo.org" target="_blank">Qgis-user@lists.osgeo.org</a>
List info: <a moz-do-not-send="true" href="http://lists.osgeo.org/mailman/listinfo/qgis-user" target="_blank">http://lists.osgeo.org/mailman/listinfo/qgis-user</a>
Unsubscribe: <a moz-do-not-send="true" href="http://lists.osgeo.org/mailman/listinfo/qgis-user" target="_blank">http://lists.osgeo.org/mailman/listinfo/qgis-user</a></pre>
</span></blockquote>
<span class="HOEnZb"><font color="#888888"> <br>
<div>-- <br>
<b><u>Richard McDonnell</u></b><br>
<b><small><small><small>GIS Specialist PgD GIS
AssocSCSI</small></small></small></b><br>
<b><small>OPW FRM Data Management</small></b><br>
<b><small>52 Stephens Green, Dublin 2.</small></b><br>
<small><small>TEL: 01 6476543</small></small></div>
<div style="font-family:Arial;font-size:8pt">
OPW - Ag féachaint don am atá le teacht - Ag caomhnú
ón am atá thart<br>
OPW - Looking to the future - Caring for the past<br>
<a moz-do-not-send="true" href="http://www.opw.ie/"
target="_blank"><img moz-do-not-send="true"
src="http://www.opw.ie/en/media/opw-email-banner.png"
height="76" width="494"></a><br>
Email Disclaimer: <a moz-do-not-send="true"
href="http://www.opw.ie/en/disclaimer/"
target="_blank">http://www.opw.ie/en/disclaimer/</a>
</div>
</font></span></div>
</blockquote>
</div>
<br>
</div>
</blockquote>
<br>
<div class="moz-signature">-- <br>
<b><u>Richard McDonnell</u></b><br>
<b><small><small><small>GIS Specialist PgD GIS AssocSCSI</small></small></small></b><br>
<b><small>OPW FRM Data Management</small></b><br>
<b><small>52 Stephens Green, Dublin 2.</small></b><br>
<small><small>TEL: 01 6476543</small></small></div>
</body>
</html>