I have a question about loading a non standard text file into an Oracle database.
The data looks like the following:
LASTNAME*FIRSTNAME MIDDLE ADDRESS*ADDRESS
LASTNAME*FIRSTNAME MIDDLE ADDRESS*ADDRESS*ADDRESS,ADDRESS
LASTNAME FIRSTNAME MIDDLE ADDRESS,ADDRESS*ADDRESS
In most cases, not all, the last past of the address is the Province/State name (Both Abbreviated and not).
I was wondering if it was possible to implement in SQL Loader the necessary logic needed to load the data into the database.
The fields that the data is to go into are:
Last_Name, First_Name, Middle_Name,
Home_Address_1, Home_Address_2, City_Town
Any help in this matter would be greatly appreciated.
Stephane C. Godbout