Hi,

I've been trying (and failing miserably) all morning to strip from a CSV file the time from it.
Can somebody point me in the right direction on how to do this using sed or awk?
The file looks like:

"James","07/20/2009-14:40:11"
"Steve","08/06/2006-02:34:37"
"John","11/03/2008-12:12:34"

"James","07/20/2009"
"Steve","08/06/2006"
"John","11/03/2008"

Possibilities, with sed:

sed 's/\(.*\)-.*/\1"/' file

awk -F, '{sub("-.*","\"",$NF)}1' OFS="," file

@Franklin52: how does the regex in the sed command skip dashes in the name? and what does the \1" do? Thanks in advance

sed has a greedy pattern match, so it should match the last dash.

With sed you can save substrings with \(.*\) and recall them back with \1, \2, \3 etc. with:

/\(.*\)-.*/

\1"/

Thank you so much Franklin!
This is just what i was looking for !

Thanks!!!!

Thanks for the explanation.