Re: Urgent: Data Migration Question?

Hi,

    I think you will have to solve the problem with either a simple program in
the language of your choice or an editor macro. My personal preference would be to write a set of vi macros as follows:

    :map v JxJxj                            Combine a 3 line group into a
singel line
    :map V vvvvvvvvvv                   Do 10 v
    :map g VVVVVVVVVV             Do 100 v
    :map q gggggggggg            DO 1000 v

regards

Jerry Gitomer

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 - 08:24:45 CDT