[R] RSQLite NA on input

R Gott richard.gott at dur.ac.uk
Tue Jan 9 15:40:53 CET 2007


Hello

I haev some .csv data files with missing values - eg below

1,'F','C04','X100',20.93,'C','B',7,8,7.5,2421,2230,2230,2,1,85,43,85,46,48,60

If I have a missing value - so file looks like ,85,46,,48, etc
then RSQLite reads it as zero.  ,85,46,0,48, etc
I need it read it as NA.

Tried various combinations with no success, adn found nothing on help
site.  Must be somehting very simple but . . . .

Help much appreciated.

Richard.



More information about the R-help mailing list