Re: Urgent: Data Migration Question?

Preprocess the file using whatever tools are available is the easiest solution. eg. UNIX: awk or shellscript, WIN: C program or other file processing utility. With a simpler file generated, then use SQL*Loader.

Scott

vishu2_at_hotmail.com wrote in message <7gu4gt$k77$1_at_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 - 07:17:24 CDT