Urgent: Data Migration Question?

From: <vishu2_at_hotmail.com>
Date: Fri, 07 May 1999 07:25:19 GMT
Message-ID: <7gu4gt$k77$1@nnrp1.deja.com>

Greetings,

I have a huge text file that needs to be loaded into Oracle database table 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 - 02:25:19 CDT