On Tue, 11-Aug-2009 at 01:39AM -0700, jorgusch wrote:
|>
|> 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.):
How did you get from here
|> 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:
to here?
|> 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
It's probably easy enough to do but we don't have anything repeatable to use.
If I make a csv file from the text string and call it junk.csv, I can
get a vector of numbers like this:
> as.numeric(gsub("[A-z.]", "", names(read.csv("junk.csv"))))
[1] 22 35 39 2 7 23 42 36 221 28
>
But there's probably more general ways if we knew more about your
position. It's likely you could use the clipboard instead of the
junk.csv text file.
HTH
|>
|> 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@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.
--
~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.
___ Patrick Connolly
{~._.~} Great minds discuss ideas
_( Y )_ Average minds discuss events
(:_~*~_:) Small minds discuss people
(_)-(_) ..... Eleanor Roosevelt
~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.
______________________________________________
R-help@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.
