I need a program to parse a text file and insert that data into an oracle database. The program needs to be designed without the use of any perl modules. Below is some sample data from the text file:
Module CST2001/K Name DATABASE THEORY & PRACTICE Tutor Year 1999/2000 ACADEMIC YEAR Period Semester 2
9801607/l Morgan Loiuse 25 PRACTICAL WORK 40 D Credit 20.00 Result P Attempt 2 Module Result 44 D Exam Board Minutes:
9763607/1 James Can 33 PRACTICAL WORK 40 D CLOSED BOOK EXAMINATION 40 D Credit 20.00 Result P Attempt 2 Module Result 40 D Exam Board Minutes:
The program would need to parse selected data such as the module number, module name etc. So I guess some sort of regular expressions willl have to be used. That data then needs to be inserted into the appropriate table field within a database.