Re: [R] Compiling date

2008-09-10 Thread Charilaos Skiadas
I have to do manually. --- On Tue, 9/9/08, Dr Eberhard W Lisse <[EMAIL PROTECTED]> wrote: From: Dr Eberhard W Lisse <[EMAIL PROTECTED]> Subject: Re: [R] Compiling date To: "David Scott" <[EMAIL PROTECTED]> Cc: "Dr Eberhard W Lisse" <[EMAIL PROTECTED]>,

Re: [R] Compiling date

2008-09-10 Thread Megh Dal
It is a mixture of both. The data is so notorious excel cant format properly. Therefore I thought whether R can do something otherwise I have to do manually. --- On Tue, 9/9/08, Dr Eberhard W Lisse <[EMAIL PROTECTED]> wrote: > From: Dr Eberhard W Lisse <[EMAIL PROTECTED]> &g

Re: [R] Compiling date

2008-09-09 Thread Dr Eberhard W Lisse
Is this Month-Day or Day-Month or a mixture of both? I still think using the Format -> Cell -> Date will work much better... el On 09 Sep 2008, at 11:21 , David Scott wrote: On Mon, 8 Sep 2008, Megh Dal wrote: Hi, I have following kind of dataset (all are dates) in my Excel sheet. 09/08/

Re: [R] Compiling date

2008-09-09 Thread stephen sefick
this is day month year? look at chron or maybe the easiest is to use excel to change the format On Tue, Sep 9, 2008 at 7:12 AM, Dr Eberhard Lisse <[EMAIL PROTECTED]> wrote: > Why not Format -> Cell in Excell? > > el > > on 9/9/08 1:03 PM Henrique Dallazuanna said the following: >> Try this: >> >>

Re: [R] Compiling date

2008-09-09 Thread Dr Eberhard Lisse
Why not Format -> Cell in Excell? el on 9/9/08 1:03 PM Henrique Dallazuanna said the following: > Try this: > > strptime(x, ifelse(nchar(x) == 8, '%d/%m/%y', '%d/%m/%Y')) > > On Tue, Sep 9, 2008 at 3:48 AM, Megh Dal <[EMAIL PROTECTED]> wrote: > >> Hi, >> >> I have following kind of dataset (al

Re: [R] Compiling date

2008-09-09 Thread Henrique Dallazuanna
Try this: strptime(x, ifelse(nchar(x) == 8, '%d/%m/%y', '%d/%m/%Y')) On Tue, Sep 9, 2008 at 3:48 AM, Megh Dal <[EMAIL PROTECTED]> wrote: > Hi, > > I have following kind of dataset (all are dates) in my Excel sheet. > > 09/08/08 > 09/05/08 > 09/04/08 > 09/02/08 > 09/01/08 > 29/08/2008 > 28/08/200

Re: [R] Compiling date

2008-09-09 Thread David Scott
On Mon, 8 Sep 2008, Megh Dal wrote: Hi, I have following kind of dataset (all are dates) in my Excel sheet. 09/08/08 09/05/08 09/04/08 09/02/08 09/01/08 29/08/2008 28/08/2008 27/08/2008 26/08/2008 25/08/2008 22/08/2008 21/08/2008 20/08/2008 18/08/2008 14/08/2008 13/08/2008 08/12/08 08/11/08 08