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