Hello all,
This is my first post so be very very very patient
I want to do a an extra special filtering but have not found the solution yet
I would like to get data from a text file and check the records and if they are good I want to write them in into a good_table and if they are not good I want to write them in the VERY_BAD_TABLE.
for example checking if the the patient insurance_no is an Integer:
table patients (insurance_no,name)
(456569076, 'Stephan') => write into the good_table
(567903123, 'Julia') => write into the good_table
(xft245677, 'John') => write into the VERY_BAD_TABLE
Thank you,
The Dark Master
