Re: [R] Different date formats in one column

2017-06-29 Thread Farnoosh Sheikhi via R-help
Thanks Jeff. This is a nice way of solving this problem. What about the cases with 0015-02-21?Many thanks. Best,Farnoosh On Wednesday, June 28, 2017 10:49 PM, Jeff Newmiller wrote: I doubt your actual file looks like the mess that made it to my email software (below) because you pos

Re: [R] Different date formats in one column

2017-06-29 Thread Farnoosh Sheikhi via R-help
Hi Christoph, There is "," between dates.Many thanks. Best,Farnoosh On Wednesday, June 28, 2017 9:05 PM, Christoph Puschmann wrote: Hey, Are all the dates connected? So no comma or space btw? Regards, Christoph > On 29 Jun 2017, at 2:02 pm, Farnoosh Sheikhi via R-help > wrote: >

Re: [R] Different date formats in one column

2017-06-29 Thread Jeff Newmiller
Left as an exercise for the student. -- Sent from my phone. Please excuse my brevity. On June 29, 2017 7:25:36 PM EDT, Farnoosh Sheikhi wrote: >Thanks Jeff. This is a nice way of solving this problem. What about the >cases with 0015-02-21?Many thanks. Best,Farnoosh > > > >On Wednesday, June 28

Re: [R] Different date formats in one column

2017-06-29 Thread Christoph Puschmann
Hey, Are all the dates connected? So no comma or space btw? Regards, Christoph > On 29 Jun 2017, at 2:02 pm, Farnoosh Sheikhi via R-help > wrote: > > Hi, > I have a data set with various date formats in one column and not sure how to > unify it.Here is a few formats: > 02091702/22/17022120

Re: [R] Different date formats in one column

2017-06-28 Thread Jeff Newmiller
I doubt your actual file looks like the mess that made it to my email software (below) because you posted HTML-format email. Read the Posting Guide, and in particular figure out how to send plain text email. You might try the "anytime" contributed package, though I suspect it too will choke on

[R] Different date formats in one column

2017-06-28 Thread Farnoosh Sheikhi via R-help
Hi,  I have a data set with various date formats in one column and not sure how to unify it.Here is a few formats: 02091702/22/170221201703/17/160015-08-239/2/1500170806May-2-201522-March-2014 I tried parse_date_time from lubridate library but it failed.Thanks so much.  Best,Farnoosh [[a