Shell Programming and Scripting

Hi all,

If I have 4 kind of files , and each file have different date, all of them are flat file and have the same 4 fields
Date|ID|Class|City

english.20060228.dat
02/28/2006|ABC|ENG|San Tomas
02/28/2006|BCD|ENG|San Jone
02/28/2006|AFD|ENG|San Luis
02/28/2006|ADD|ENG|San Mateo

english.20060227.dat
02/27/2006|ABC|MTH|San Tomas
02/27/2006|BBD|ENG|San Jone
02/27/2006|HFD|ENG|San Luis
02/27/2006|RRR|PHY|San Mateo


Spanish.20060228.dat
02/28/2006|AXC|ENG|San Tomas
02/28/2006|BXD|ENG|San Jone
02/28/2006|AXD|ENG|San Luis
02/28/2006|AXD|ENG|San Mateo

Spanish.20060227.dat
02/27/2006|ANC|SPASan Tomas
02/27/2006|BND|HUH|San Jone
02/27/2006|AND|WEL|San Luis
02/27/2006|AND|TET|San Mateo


france.20060228.dat
02/28/2006|AMC|EWW|San Tomas
02/28/2006|BMD|WRE|San Jone
02/28/2006|AMD|RGG|San Luis
02/28/2006|AMD|EWW|San Mateo

france.20060227.dat
02/27/2006|QYQ|MTH|San Tomas
02/27/2006|BYD|ENG|San Jone
02/27/2006|AYD|ENG|San Luis
02/27/2006|AYD|PHY|San Mateo


Dummy.20060228.dat
02/28/2006|AKC|ENGD|San Tomas
02/28/2006|BKD|ENGD|San Jone
02/28/2006|AKD|ENGD|San Luis
02/28/2006|AKD|ENGD|San Mateo

Dummy.20060227.dat
02/27/2006|AIC|MTHD2|San Tomas
02/27/2006|BID|ENGD2|San Jone
02/27/2006|AID|ENGD2|San Luis
02/27/2006|AID|PHYD2|San Mateo

how do I write a code to combine all file english*.dat , spanish*.dat , france*.dat NOT DUMMY.dat and it should have combine.date.log and combine.date2.log ( and new containt sort by ID and CLASS).... like combine.20060227.log , combine.20060228.log

How it can go to this directory and do in one script ??
can we do it in korn shell ?

Thanks

Something to start with - you take it from here!

Code:

#!/bin/ksh

#file='Dummy.20060227.dat'

for file in *.dat
do
   nd="${file%.*}"
   name="${nd%%.*}"
   date="${nd##*.}"
   #echo "name->[${name}] date->[${date}]"
   cat "${file}" >> "combine.${date}.log"
done

It is not what I expected . The comebine. date.log will contain english.date.log,spanish.date.log,france.date.log and NOT DUMMY.date.log, some how your code is combine.english.date.log and it is exactly english.date.dat

that's not what I'm seeing here given your files and the naming conventions.
Either way - try to understand the code and change it the way you want it.