[datatable-help] fread (boolean?) problem in 1.8.11 rev 971

Simon Biggs spbiggs at hotmail.com
Fri Sep 20 19:16:50 CEST 2013


Hi

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?)

Loading my file with a basic call to fread() results in the error:

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 
Happy to provide the full file if you let me know how.  First couple of rows reproduced below (file is tab delimited):
 
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
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
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
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
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

Many thanks for your efforts

Simon
 		 	   		  
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.r-forge.r-project.org/pipermail/datatable-help/attachments/20130920/c8970159/attachment.html>


More information about the datatable-help mailing list