Try this:
# Lines <- readLines('your_file')
Lines <- "Ny:23-45 AC
BA:88-91 DB
KJ:21-13 PA"
DF <- read.table(textConnection(gsub("[-:]", "\t", Lines)))
closeAllConnections()
On Thu, Jul 29, 2010 at 2:34 PM, kayj <[email protected]> wrote:
>
> Hi All,
>
> I have a dataset that I would like to split based on : or ( the data file
> is tab delimited) for example:
> Ny:23-45 AC
> BA:88-91 DB
> KJ:21-13 PA
>
> And I would like the data to be splitted and the final results look like
> NY 23 45 AC
> BA 88 91 DB
> KJ 21 13 PA
>
> I would like to have the resulting data as a data frame so each column is a
> variable.
>
> Thanks,
>
>
> --
> View this message in context:
> http://r.789695.n4.nabble.com/help-splitting-a-data-frame-tp2306832p2306832.html
> Sent from the R help mailing list archive at Nabble.com.
>
> ______________________________________________
> [email protected] 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.
>
--
Henrique Dallazuanna
Curitiba-Paraná-Brasil
25° 25' 40" S 49° 16' 22" O
[[alternative HTML version deleted]]
______________________________________________
[email protected] 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.
