<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<div class="moz-cite-prefix">Hi,<br>
Many thanks. Now fixed - commit 973.<br>
Matthew<br>
<br>
On 20/09/13 18:16, Simon Biggs wrote:<br>
</div>
<blockquote cite="mid:BAY167-W8440CA7BCBC3FF2B87E143B4220@phx.gbl"
type="cite">
<style><!--
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 12pt;
font-family:Calibri
}
--></style>
<div dir="ltr">Hi<br>
<br>
I'm finding data.table excellent for processing of significant
numbers of large files. Trying out the latest build I'm seeing
some problems (perhaps around the new boolean support?)<br>
<br>
Loading my file with a basic call to fread() results in the
error:<br>
<br>
<span style="font: 13px/15px "Lucida Console"; color:
rgb(0, 0, 0); text-transform: none; text-indent: 0px;
letter-spacing: normal; word-spacing: 0px; white-space:
pre-wrap; border-collapse: separate; orphans: 2; widows: 2;
font-size-adjust: none; font-stretch: normal;
background-color: rgb(225, 226, 229);"
class="ecxApple-style-span">
<pre style="line-height: 1.2; font-family: "Lucida Console"; font-size: 10pt !important; white-space: pre-wrap !important; outline-style: none;" class="ecxGNVMTOMCABB" tabindex="0"><span style="color: rgb(197, 6, 11);" class="ecxGNVMTOMCLAB ecxace_constant">Error in fread("file.txt") :
Expected sep (' ') but 'T' ends field 25 on line 2 when detecting types: 8878 1 1 24 4 AFY057250G12 NA 2012-07-01 2013-06-30 1e+05 49999100.7232666 1.58e+08 0 33176.21 978 NA 1 EUR 0 EUR 0 EUR TERRINC HXG T</span></pre>
</span> <br>
Happy to provide the full file if you let me know how. First
couple of rows reproduced below (file is tab delimited):<br>
<br>
Key Id AKey PKey Peril PNum LName EDt ExDt PAPt PL PPof PD Prem CurrencyKey RK IsV CurrencyCd minDedAmt minDedCur maxDedAmt maxDedCur userIdTxt1 userIdTxt2 userIdTxt3 userIdTxt4 PStat<br>
8878 1 1 24 4 AFY05 NA 2012-07-01 2013-06-30 1e+05 49999100.7232666 1.58e+08 0 33176.21 978 NA 1 EUR 0 EUR 0 EUR TERRINC HXG T TO NA<br>
8878 1 3 93 4 AFJ02 NA 2012-03-31 2014-03-30 150000 3.5e+07 1.4e+08 0 3688.44 840 NA 1 USD 0 USD 0 USD TERRINC JGP T TO NA<br>
8878 1 6 95 4 AFY08 NA 2012-04-08 2013-04-07 1e+05 29999983.4435654 336907000 0 0 826 NA 1 GBP 0 GBP 0 GBP TERRINC SPT T TU NA<br>
8878 1 7 17 4 AFR1 NA 2012-07-12 2013-06-30 7500000 5e+07 5e+08 0 10319.34 840 NA 1 USD 0 USD 0 USD TERREXC JGP T TO NA<br>
<br>
<font color="#444444">Many thanks for your efforts<br>
<br>
Simon</font><br>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
datatable-help mailing list
<a class="moz-txt-link-abbreviated" href="mailto:datatable-help@lists.r-forge.r-project.org">datatable-help@lists.r-forge.r-project.org</a>
<a class="moz-txt-link-freetext" href="https://lists.r-forge.r-project.org/cgi-bin/mailman/listinfo/datatable-help">https://lists.r-forge.r-project.org/cgi-bin/mailman/listinfo/datatable-help</a></pre>
</blockquote>
<br>
</body>
</html>