I have hundreds of CSV files coming in from another program that have a text field representing the date & time combined together. I need to strip the time and keep the date. How could I do that?
In the example below, on the first line I need to keep the 6/15/2009, turning it into a date that R recognizes, but I need to throw away the time portion completely. > read.csv("C:\\D1\\F1-V1.csv", header=FALSE)[,c(1,7)] V1 V7 1 6/10/2009 10:04:00 AM 91 2 6/15/2009 9:47:00 AM -279 3 6/15/2009 9:47:00 AM 861 4 6/22/2009 9:47:00 AM 771 5 6/22/2009 4:01:00 PM -179 6 6/24/2009 2:53:00 PM 61 7 7/2/2009 9:47:00 AM 491 8 7/6/2009 9:47:00 AM 81 9 7/13/2009 10:04:00 AM 1681 Thanks, Mark ______________________________________________ R-help@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.