need help removing time from a csv file need help removing time from a csv file unix unix

need help removing time from a csv file


Python

import csvimport datetimerdr = csv.reader( open("someFile.csv", "rb" ) )rows = list( reader )rdr.close()def byDateTime( aRow ):    return return datetime.datetime.strptime( aRow[1], "%m/%d/%Y-%H:%M:%S" )rows.sort( key= byDateTime )wtr = csv.writer( open("sortedFile.csv", "wb" ) )wtr.writerows( rows )wtr.close()


cut -d '-' -f 1 file

Edit after comment:

sed 's/-[0-9][0-9]:[0-9][0-9]:[0-9][0-9]//g' file


just use awk

awk -F"," '{ split($2,_,"-"); print $1,_[1] }' OFS="," file