Hi All,

I got a file with 3 fields delimited by hyphen "-". I have to validate & cleanse the data before i begine the processing

Requirements

1. No record should contain more than 2 delimiters
2. No record should even contain less than 2 delimiters
3. Any records that matches rule 1 & 2 should be captured to
bad_records.dat
4. Delete records satisfying rules 1 & 2 from original incoming data file


Sample Format

input.dat
COL1-COL2-COL3
scott-2000-10
tiger-1000-20
c-bill-1000-30
mike20-1000

so after the validation&cleansing process, the data should appear like below

input.dat
scott-2000-10
tiger-1000-20

bad_records.dat
c-bill-1000-30
mike20-1000

Please note i can't use perl progressive scanning. I need to achieve this via korn shell script


Thanks guys

Just curious, is this homework?
Anyhow, look in to awk. I've always found awk as my good friend.

-Nitin

No double, or triple posting of questions.

The UNIX and Linux Forums - Forum Rules

for inputfile in *.dat
do
awk ' {good=sprintf("%s.%s", FILENAME, "good")
          bad=sprintf("%s.%s", FILENAME, "bad")
       if(NF==3) { print $0 > good} else {print $0 >bad}}'  $inputfile
done