You can read the data in, then use 'grep' to determine which rows
match, then write the files out:
x <- read.table(....)
rowIndx <- grep("Sick|CB", x$col)
write.table(x[rowIndx,], file="match")
write.table(x[-rowIndx,], file="nomatch")
On Fri, Oct 3, 2008 at 2:48 PM, kayj <[EMAIL PROTECTED]> wrote:
>
> Hi,
>
> I have a txt file here I want to split it into different files based on the
> column name if it contains a specific word or part of a word. For example,
>
> If the header looks like
>
> A001_Sick A015_SB K99_Sick L913_BB
>
> I would like to split the data , one file contains the data with column
> names containing the words "Sick" or "SB" and have the rest of the data in
> another file.
>
> I appreciate your help,
>
>
>
>
>
>
>
> --
> View this message in context:
> http://www.nabble.com/Splitting-a-file-into-multiple-files-based-on-the-column-name-tp19803535p19803535.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.
>
--
Jim Holtman
Cincinnati, OH
+1 513 646 9390
What is the problem that you are trying to solve?
______________________________________________
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.
