Compare date in a csv file

research3 · #1 (**permalink**) 12-08-2008

Hi all,

how can I compare two defferent lines in a csv file, with the date values,
and print the latest date!

example:

cat test.csv

test1;whatever;Wed Nov 26 14:17:48 CET 2008
test1;whatever;Wed Nov 26 17:14:06 CET 2008

Any suggession?

ahmedwaseem2000 · #2 (**permalink**) 12-08-2008

not sure though. try something like this.

Code:

awk '{getline nextline; if ( nextline == $0 ) print "MATCHING" }' filename

research3 · #3 (**permalink**) 12-08-2008

sorry, no result.

I mean, my goal is to compare the date "Wed Nov 26 17:14:06 CET 2008" and "Wed Nov 26 14:17:48 CET 2008" parts with the current date and print the latest one!

sha7khan · #4 (**permalink**) 12-08-2008

something like following should work.

cat file.csv | awk -F\; '{printf "%s,",$0;system ("date +%s -d " "\""$3"\"" );}' |sort -n

research3 · #5 (**permalink**) 12-08-2008

Thanks a lot sha7khan!

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
Compare date from db2 table to yesterday's Unix system date	sasaliasim	Shell Programming and Scripting	9	12-01-2008 11:37 PM
Compare date of file and directory	odd_r	Shell Programming and Scripting	2	08-26-2008 10:39 AM
compare date with date in file	siog	UNIX for Dummies Questions & Answers	2	10-04-2006 01:10 PM
compare today's date with date in a file	siog	UNIX for Dummies Questions & Answers	4	10-04-2006 12:55 PM
Log File date compare for user defined range	mojo24	Shell Programming and Scripting	0	05-05-2006 07:39 AM

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode	Rate This Thread:


	Powered by