Shell Programming and Scripting

hello,

I have the following script to check the invoice number is in order or not.
However, it cannot show out the correct information. My expect output show below and I would like to only list out the NOT IN SEQUENCE inovice number (not included "ok")

#!/bin/sh
start=1
for file_number in `ls -1 /appl/appl/archive/client/CACHE/CLIENTINVOICE*[0-9].archived | sort | cut -c 48,49,50,51`
do
if [ $start -eq 1 ] ; then
# this is the first pass of the loop, so we've got nothing to compare
start=0
previous=$file_number
else
# this is not the first pass of the loop
previous=`expr $previous + 1`
echo "comparing $file_number and $previous ... "
if [ $file_number = $previous ] ; then
echo "OK"
else
seqno=`expr $file_number - 1`
echo "CLIENTINVOICE$invoiceno are not in sequence "
fi
fi
previous=$file_number
done


input:
01185
01191
01192
01193
01196
01197
.
.
.

script output:
01190 are not in seq
01195 are not in seq

expect output
01186 are not in seq
01187 are not in seq
01188 are not in seq
01189 are not in seq
01190 are not in seq
01194 are not in seq
01195 are not in seq

Code:

#! /opt/third-party/bin/perl

open(FILE, "<", a) || die "Unable to open file <$!>\n";

while(<FILE>) {
  chomp;
  if ( not defined $first ) {
    $first = $_;
    next;
  }
  for( $i = $first + 1; $i < $_; $i++ ) {
    print "0$i are not in seq\n";
  }
  $first = $_;
}

close(FILE);

exit 0

Chk this:

Code:

awk '{ if (NR==1){ dat=$1; }else { while(++dat<$0) printf "%05d Are not in seq \n",  dat    }  }' filename

Output:

01186 Are not in seq
01187 Are not in seq
01188 Are not in seq
01189 Are not in seq
01190 Are not in seq
01194 Are not in seq
01195 Are not in seq

Great, it work...but I problem..due to the directory have a lot of different group of invoice such as
CLIENTINVOICE*[0-9].archived
CLIENTBINVOICE*[0-9].archived
CLIENTCINVOICE*[0-9].archived


Can I output the result which the group name as well..? so that i can do summary for each group of missing.

expected:
CLIENTINVOICE01187 Are not in seq
CLIENTINVOICE01188 Are not in seq
CLIENTINVOICE01189 Are not in seq
CLIENTINVOICE01190 Are not in seq
CLIENTINVOICE01194 Are not in seq
CLIENTBINVOICE02201 Are not in seq
CLIENTBINVOICE02203 Are not in seq
CLIENTCINVOICE02203 Are not in seq
CLIENTCINVOICE02207 Are not in seq
CLIENTCINVOICE02212 Are not in seq

Could you explain the problem with an example..

I just want to have more output detail. your output:

Output:

01186 Are not in seq
01187 Are not in seq
01188 Are not in seq
01189 Are not in seq
01190 Are not in seq
01194 Are not in seq
01195 Are not in seq

my expected output (due to the file with a lot of client group in it)

group type:
CLIENTINVOICE*[0-9].archived
CLIENTBINVOICE*[0-9].archived
CLIENTCINVOICE*[0-9].archived

output:
CLIENTINVOICE01187 Are not in seq
CLIENTINVOICE01188 Are not in seq
CLIENTINVOICE01189 Are not in seq
CLIENTINVOICE01190 Are not in seq
CLIENTINVOICE01194 Are not in seq
CLIENTBINVOICE02201 Are not in seq
CLIENTBINVOICE02203 Are not in seq
CLIENTCINVOICE02203 Are not in seq
CLIENTCINVOICE02207 Are not in seq
CLIENTCINVOICE02212 Are not in seq

Code:

input:
01185
01191
01192
01193
01196
01197

the input you gave is of the above form
is the input still the same ?
if so,

how is it possible to categorize as CLIENT, CLIENTB, CLIENTC ?
Is there any logic based on the numbers ?
To me its still not clear!

Again your sample input and expected output would be of great help!