basic "date" issue

Hi all,

I think my problem is very basic but I could not manage to convert a dataframe
(from clipboard for example) to xts object or at least convert the first
variable of that frame as a date which is suitable for several financial
packages we can use at R.

Dataset <- read.table("clipboard", header=FALSE, sep="", na.strings="NA",

+   dec=",", strip.white=TRUE)

Dataset

          V1             V2       V3            V4            V5
V6          V7              V8
1 18.04.2006     00:00 54023.33 52627.51 54018.08 7.46  99.775.064   744.426.000
2 19.04.2006     00:00 55883.34 54018.08 55229.30 7.75 131.305.744 1.017.725.000
3 20.04.2006     00:00 55537.81 54762.96 55381.24 8.11  76.387.088   619.336.500
4 21.04.2006     00:00 57035.53 55207.06 57035.53 7.80 141.309.104 1.102.106.000
5 24.04.2006     00:00 57612.70 56493.95 57293.77 7.85 127.384.064   999.678.700
6 25.04.2006     00:00 57891.10 57151.94 57395.92 7.91 139.710.544 1.105.421.000

class(Dataset)

[1] "data.frame"

as.xts(Dataset)

Error in as.POSIXlt.character(x, tz, ...) :
  character string is not in a standard unambiguous format

class(Dataset$V1)

[1] "factor"

as.Date(Dataset$V1)

Error in charToDate(x) :
  character string is not in a standard unambiguous format

I also tried the format tricks such as "%d-%m-%Y" or alike.. I will go crazy!!
:)

so, how can I turn this dataframe to "xts" and how can I convert V1 to a 'date'
format recognized by the finance packages in R environment?

Best,
Fatih


       [[alternative HTML version deleted]]