[R] Slicing cra**y csv files

[John Kane]

There was a couple of strange characters in the post so I am not sure that I understand exactly what the data looks like but if you are getting a vector of results that look like
"22 Results","35 Results","39 Results","2 Results","7 Results","23 Results", "42 Results","36 Results","22 Results","28 Results"


Then I think that something like this will work where x is your data.

x <- c("22 Results","35 Results","39 Results","2 Results","7 Results","23 Results", "42 Results","36 Results","22 Results","28 Results")
x1 <- strsplit(x, " ")  
x2  <- as.data.frame(do.call("rbind",x1)) 

(chiffres <- as.numeric(as.character(x2[,1]))

--- On Tue, 8/11/09, jorgusch <hackl.schorsch at web.de> wrote:

> From: jorgusch <hackl.schorsch at web.de>
> Subject: [R]  Slicing cra**y csv files
> To: r-help at r-project.org
> Received: Tuesday, August 11, 2009, 4:39 AM
> 
> Hello,
> 
> For not too regular users of R, preparing the data is
> somehow a burden.
> 
> Comming from iMacro in FireFox I get a badly designed csv,
> which I need to
> put into a daily R script. 
> The data looks like that (e.g.):
> 22 Results,"35 Results","39 Results","2 Results","7
> Results","23
> Results","42 Results","36 Results","22 Results","28
> Results"
> 
> and R does this to it:
>          
>    V1     
>    V2     
>    V3        V4 
>       V5     
>    V6        
> V7
> 1 22 Results 35 Results 39 Results 2 Results 7
> Results 23 Results 42
> Results
>           V8     
>    V9        V10
> 1 36 Results 22 Results 28 Results
> 
> I just need the numbers as a vector.
> 
> Excel can do it with a few lines of VBA, but there must be
> a way to do it
> directly in R, would make things easier.
> 
> Thanks a lot!
>  jorgusch
> -- 
> View this message in context: http://www.nabble.com/Slicing-cra**y-csv-files-tp24913849p24913849.html
> Sent from the R help mailing list archive at Nabble.com.
> 
> ______________________________________________
> R-help at r-project.org
> mailing list
> https://stat.ethz.ch/mailman/listinfo/r-help
> PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
> and provide commented, minimal, self-contained,
> reproducible code.
> 


      __________________________________________________________________
Looking for the perfect gift? Give the gift of Flickr! 

http://www.flickr.com/gift/