Urgent: Data Migration Question?
Date: Fri, 07 May 1999 07:25:19 GMT
Message-ID: <7gu4gt$k77$1_at_nnrp1.deja.com>
Greetings,
[Quoted] [Quoted] I have a huge text file that needs to be loaded into Oracle database table [Quoted] and the format of the data in the file is as follows:
LNAME1 % FNAME1 % MNAME1 % DOB % ADDRESS %^ CITY % STATE % ZIP % PHONE_NO % SSN %^ COMMENTS %^ LNAME2 % FNAME2 % MNAME2 % DOB % ADDRESS %^ CITY % STATE % ZIP % PHONE_NO % SSN %^ COMMENTS %^
and so on ....
The layout of the source file is such that it is not wrapped but a carraige return represented by "^" in the above example, even though it is the same record. Thus one single record is spread for three lines and I am having trouble parsing it to make look as a single record using SQL*Loader to do the upload.
How to do the upload and map the huge amount of data. How can I concatanate the three lines into one single record?
Any help would be greatly appreciated.
Thanks in advance
Vishwa
vishu2_at_hotmail.com
-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Fri May 07 1999 - 09:25:19 CEST