Home » RDBMS Server » Server Administration » Re: How do i breakup a TXT file and save it as multiple records?????
Re: How do i breakup a TXT file and save it as multiple records????? [message #370291] Wed, 04 August 1999 11:07 Go to next message
Chris Hunt
Messages: 27
Registered: March 1999
Junior Member
Hmmmm... difficult to say without seeing the file in question, but my guess is that you'll be better off using Perl or awk to massage the inbox file into a format friendly to SQL*Loader (or whatever the Oracle8 equivalent is).

The alternative is to read the file in however you can (SQL*Loader, UTL_FILE, whatever) into a temporary table of long VARCHAR2 fields, then write some PL/SQL to extract this how you want it.

I suppose it depends what skills you have/want to learn.

Chris Hunt : Re: How do i breakup a TXT file and save it as multiple records????? [message #370294 is a reply to message #370291] Thu, 05 August 1999 14:08 Go to previous message
arvin
Messages: 4
Registered: August 1999
Junior Member
hi chris,
thanks for the mail.
The file in question is the INBOX file of outlook.
can u please send me a sample code, for finding the delimiter in the inbox file which separates messages, and then parese it into individual files
I am looking into the UTL_FILE utility.
please give me some suggestions
Previous Topic: Re: ORDER BY clause - easy question
Next Topic: Re: escape / single char wildcard
Goto Forum:
  


Current Time: Fri Oct 23 17:02:26 CDT 2020