Fantastic! Thanks!
--
David C. Sisk
Need tech info on Oracle? Visit The Unofficial ORACLE on NT site at
http://www.ipass.net/~davesisk/oont.htm
Like original modern rock? Listen to song samples and buy a CD at
http://www.mp3.com/disparityofcult
Raleigh music compilation! All $$$ go to NC Food Bank.
http://www.mp3.com/whisper2ascream
Cam White wrote in message ...
>A Generic String Parsing Package with unwrapped source code comes free when
>you download the Trial version of the Active Pl/SQL Knowledge Base from
>http://www.revealnet.com You will also find a string parsing utility in
the
>"Archives" section of the PL/SQL Pipeline - a free internet community for
>PL/SQL development. http://www.revealnet.com/plsql-pipeline/index.htm
>
>Best wishes,
>
>Cam White
>RevealNet, Inc.
>David Sisk wrote in message <1x5N4.53$c71.304_at_saturn.ipass.net>...
>>I've got a big batch of ascii data coming in via the UTL_HTTP package.
It's
>>pretty slick for getting the data, but man is it ugly to try to get it
into
>>columns. The majority of it is comma delimited values, but then there's
>>some lines that are different (such as comma delimited column headers,
plus
>>some header data that is not comma delimited). Each line has a CRLF
>>character behind it. Finally, this may be 10K or more of data, but it's
>>split into 2K chunks, which does not necessarily split it where the CRLF's
>>are. Some of the numeric values include fractions rather than decimal
>>numbers.
>>
>>I want to take the first two lines (meaning lines ending with a CRLF) and
>>seperate the string into data to go into columns in one table, then take
the
>>remaining lines and seperate those into data to go into columns in a
second
>>table. Essentially, take this ugly bunch o' stuff and insert it neatly
into
>>the necessary table columns.
>>
>>I'm a competent DBA, but not an expert PL/SQL developer. So, using
PL/SQL,
>>does anyone have any recommendation on the best way to do this task? Any
>>functions that might prove very useful, etc.?
>>
>>Best regards,
>>
>>
>>
>>--
>>David C. Sisk
>>Need tech info on Oracle? Visit The Unofficial ORACLE on NT site at
>>http://www.ipass.net/~davesisk/oont.htm
>>Like original modern rock? Listen to song samples and buy a CD at
>>http://www.mp3.com/disparityofcult
>>Raleigh music compilation! All $$$ go to NC Food Bank.
>>http://www.mp3.com/whisper2ascream
>>
>>
>>
>
>
Received on Wed Apr 26 2000 - 00:00:00 CDT
