Re: [R] extract date time from a text file

From: Joris Meys <jorismeys_at_gmail.com>
Date: Fri, 18 Jun 2010 18:33:32 +0200

As the footer says:
> PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
> and provide commented, minimal, self-contained, reproducible code.

There's probably another way using readLines or so to do it in one try, but say you used :
frame <- read.delim("some_file.ext")

then

library(chron)
newframe$name <- paste(frame[,3],frame[,4]) newframe$dates <- chron(frame[,1],frame[,2],format=c(dates = "y/m/d", times = "h:m:s"))

Cheers
Joris

On Fri, Jun 18, 2010 at 4:58 PM, Sebastian Kruk <residuo.solow_at_gmail.com> wrote:
> I a have a text file where every line is like that:
>
> "2007-12-03 13:50:17 Juan Perez"
> ("yy-mm-dd hh:mm:ss First Name Second Name")
>
> I would like to make a data frame with two column one for date and the
> other one for name.
>
> When I use read.delim it was transformed in a data frame with 4 colums.
>
> Bye,
>
> Sebastián.
>
> ______________________________________________
> 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.
>

-- 
Joris Meys
Statistical consultant

Ghent University
Faculty of Bioscience Engineering
Department of Applied mathematics, biometrics and process control

tel : +32 9 264 59 87
Joris.Meys_at_Ugent.be
-------------------------------
Disclaimer : http://helpdesk.ugent.be/e-maildisclaimer.php

______________________________________________
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.
Received on Fri 18 Jun 2010 - 16:36:51 GMT

Archive maintained by Robert King, hosted by the discipline of statistics at the University of Newcastle, Australia.
Archive generated by hypermail 2.2.0, at Fri 18 Jun 2010 - 17:40:33 GMT.

Mailing list information is available at https://stat.ethz.ch/mailman/listinfo/r-help. Please read the posting guide before posting to the list.

list of date sections of archive