Displaying 2 results from an estimated 2 matches for "quoation".
Did you mean:
quotation
2005 Aug 14
1
parse():ing a unclosed string
When parse():ing R code from *file* with a unclosed string, that is, a
string that has an open quoation mark, but not a ending one, the string
seems to be closed automagically. Is this a "bug"?
Example:
> code <- "x <- '123";
> parse(text=code) # Gives an error as expected
Error in parse(file, n, text, prompt) : parse error
> cat(file="foo...
2011 Jul 14
1
SQldf with sqlite and H2
...a large csv file (about 2GB) and wanted to import the file into R and do some filtering and analysis. Came across sqldf ( a great idea and product) and was trying to play around to see what would be the best method of doing this. csv file is comma delimited with some columns having comma inside the quoation like this "John, Doe".
I tried this first
#######
library(sqldf)
sqldf("attach testdb as new")
In.File <- "C:/JP/Temp/2008.csv"
read.csv.sql(In.File, sql = "create table table1 as select * from file",
dbname = "testdb")
It errored out wit...