UNIX for Dummies Questions & Answers

Hi everyone,

I have problem where I need to convert numbers to date format and then figure out what is less than or equal to specific date, the data comes out of a report in the following format

071205
141005
091205
111105
051005
141005
261005
181005

so I need to firstly run through the file taking the first line as the 7th of December 2005 etc, etc!, after which I then need to be able to extract the ones that are equal to or less than a given date


any help would be greatly appreciated...

This might be complex but the below script will give you the dates lesser than the passed date

Code:

#!/bin/ksh
inputdate=`echo $1 | sed 's/^\(..\)\(..\)\(..\)$/\3\2\1/'`
for i in `sed 's/^\(..\)\(..\)\(..\)$/\3\2\1/' datafile| sort -n`
do
if [ i -le inputdate ] 
then
echo $i | sed 's/^\(..\)\(..\)\(..\)$/\3\2\1/' 
fi
done

Change the date for /tmp/BASE as you need

gerry.txt is the file containing the 6-digit date format

Code:

#! /bin/sh
# gerry.sh
# input  071205
# output Dec 07 2005
#

# Base date is Oct 19, 2005.
touch -d "Oct 19 05" /tmp/BASE 

while read line
do
        DAY=${line%????}
        line=${line#$DAY}
        MON=${line%??}
        YR=${line#??}

        case "$MON" in
        "01") mon=Jan ;;
        "02") mon=Feb ;;
        "03") mon=Mar ;;
        "04") mon=Apr ;;
        "05") mon=May ;;
        "06") mon=Jun ;;
        "07") mon=Jul ;;
        "08") mon=Aug ;;
        "09") mon=Sep ;;
        "10") mon=Oct ;;
        "11") mon=Nov ;;
        "12") mon=Dec ;;
        esac

        touch -d "$mon $DAY $YR" /tmp/FILEOLD
        if [ "/tmp/FILEOLD" -nt "/tmp/BASE" ] ; then
        echo "$mon $DAY $YR is newer"
        else
        echo "$mon $DAY $YR is older"
        fi ;
done < gerry.txt

rm -f /tmp/BASE /tmp/FILEOLD

vino

Hi thanks for those, but none of them seem to work on my flavour DataGeneral unix

monsanbu

From the first script I get lots of the following:
inputdate: bad number
inputdate: bad number
inputdate: bad number
inputdate: bad number
inputdate: bad number
inputdate: bad number
inputdate: bad number
inputdate: bad number
inputdate: bad number
inputdate: bad number
inputdate: bad number
inputdate: bad number

VINO
I don't seem to have the "-d" option, so I have dumped an extract from the man pages below to hopefully help in solving

SYNOPSIS
touch [ -amc ] [-r ref_file | -t time] files
touch [ -amc ] [ mmddhhmm[yy] ] files

DESCRIPTION
Touch updates the access and modification times of each argument. If no time is specified the current time is used.
(See date(1) for a description of the second synopsis' time format.)

Options are:

-a Update only the access time.

-m Update only the modification time.

If neither -a nor -m is specified, the effect is the same as
-am.

-c Silently prevent touch from creating the file if it did not
previously exist.

-r ref_file
Use the corresponding time of ref_file instead of the current
time.

-t time Use time instead of the current time. time is a decimal
number of the form:
[[CC]YY]MMDDhhmm[.SS]

where each two digits represent the following:
MM month of the year (01-12)
DD day of the month (01-31)
hh hour of the day (00-23)
mm minute of the hour (00-59)
CC first two digits of the year (the century)
YY second two digits of the year
SS second of the minute (0-61)

CC and YY are optional. If neither is given, the current
year is assumed. If YY is specified, but CC is not, CC is
derived as follows:
If YY is: CC becomes:
------------------------
69-99 19
00-68 20

The range for SS is (00-61), because of leap seconds. If SS
is 60 or 61 and the resulting time, as affected by the TZ
environment variable, does not refer to a leap second; the
resulting time shall be one or two seconds after a time where
SS is 59. If SS is not given it is assumed to be zero.

DIAGNOSTICS
The following exit values are returned:

0 The utility executed successfully and all requested changes
were made.

>0 An error occurred.

SEE ALSO
date(1).
utime(2)

NOTESe--
The -t time option should be used in preference to the second
synopsis usage, since the second synopsis may not be supported in
future releases.

Change

Code:

touch -d "Oct 19 05" /tmp/BASE

to

Code:

touch -t 0509190000 /tmp/BASE

and

Code:

touch -d "$mon $DAY $YR" /tmp/FILEOLD

to

Code:

touch -t "$YR$mon$DAY0000" /tmp/FILEOLD

Vino

Hi Again Vino,


Sorry to be a pain but I now get an error..
UX:sh (./DateVino): ERROR: Bad substitution

#! /bin/sh
# gerry.sh
# input 071205
# output Dec 07 2005
# Base date is Oct 19, 2005.

touch -t 0509190000 /tmp/BASE

while read line
do
DAY=${line%????}
line=${line#$DAY}
MON=${line%??}
YR=${line#??}

case "$MON" in
"01") mon=Jan ;;
"02") mon=Feb ;;
"03") mon=Mar ;;
"04") mon=Apr ;;
"05") mon=May ;;
"06") mon=Jun ;;
"07") mon=Jul ;;
"08") mon=Aug ;;
"09") mon=Sep ;;
"10") mon=Oct ;;
"11") mon=Nov ;;
"12") mon=Dec ;;
esac
touch -t "$YR$mon$DAY0000" /tmp/FILEOLD
if [ "/tmp/FILEOLD" -nt "/tmp/BASE" ] ; then
echo "$mon $DAY $YR is newer"
else
echo "$mon $DAY $YR is older"
fi ;
done < gerry.txt

rm -f /tmp/BASE /tmp/FILEOLD

Vino, you are on Linux. Your /bin/sh is really bash. Gerry405, your /bin/sh is really the Bourne shell. You will need to use ksh or bash to run that script.