Compare dates in a field and print the latest date row

cvkishore · #1 (**permalink**) 08-04-2007

Hi,

I need a shell script which should find the latest date in the field of file and print that line only. For eg.,

I have a file /date.log

Name Date Status
IBM 06/06/07 close
DELL 07/27/07 open
DELL 06/07/07 open
: : :

From this I want to find out the latest date (07/27/07) and print the line (DELL 07/27/07 open).

This is very very useful for me at my work. Please help me.

Thanks in Advance
CVKishore

Shell_Life · #2 (**permalink**) 08-04-2007

Code:

mPrevCmpy="First"
sort input_file | while read mCmpy mDate mStatus
do
  if [ "${mCmpy}" != "${mPrevCmpy}" ]; then
    if [ "${mPrevCmpy}" != "First" ]; then
      echo ${mLine}
    fi
    mLatest=""
  fi
  mDD=`echo ${mDate} | cut -c1-2`
  mMM=`echo ${mDate} | cut -c4-5`
  mYY=`echo ${mDate} | cut -c7-8`
  mYYMMDD=${mYY}${mMM}${mDD}
  if [ "${mYYMMDD}" > "${mLatest}" ]; then
    mLine=${mCmpy}' '${mDate}' '${mStatus}
    mLatest=${mYYMMDD}
  fi
  mPrevCmpy=${mCmpy}
done
if [ "${mPrevCmpy}" != "First" ]; then
  echo ${mLine}
fi

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
compare dates...	i_priyank	Shell Programming and Scripting	3	09-21-2007 12:50 AM
compare dates	ragha81	Shell Programming and Scripting	2	11-01-2006 06:17 PM
How to compare dates in C/C++	naan	High Level Programming	1	08-28-2006 10:03 AM
How to compare two dates	bankpro	High Level Programming	5	01-24-2006 04:07 AM
latest status of an field in a log file	encrypted	UNIX for Dummies Questions & Answers	2	07-16-2004 04:05 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