Skip to content
Prev 80868 / 398502 Next

strsplit

Tom
I'm stuck on what I feel should be a minor problem.
I have a dataseries obtained from a MS Access database that consists of
a series of numbers seperated by carridge returns (\r)
Currently this data is in R as mode numeric???

I want to separate this into a vector of the componant numbers.
Perhaps a little code will help describe what I've got here!!

library(rodbc)
s_sql<-'SELECT Data from table where id=1' #only one record returned
oWave<-sqlQuery(oConn,s_sql)

wave.data<-oWave$data
[1] "numeric"

Any clues will be much appreciated
thanks
Tom