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]]